roles is not mapped [select r from roles r where r.user_id=:id ] code example

Example: query syntax exception is not mapped

@Query( value = "some sql query ...", nativeQuery = true)