added native query and persist new entity

Signed-off-by: Lyndon Michael Bibera <secret.transaction@gmail.com>