Very useful. Let me share an workaround if you still want your entity/table to be named User.
Background: Hibernate creates a query like this:
select
user0_.id as id0_,
user0_.first_name as first2_0_,
user0_.last_name as last3_0_,
from
user user0_
This user in the from clause messes the things.
The work around is to specify your schema. Can be done in two ways

1. By specifying the schema in the table in the @Table annotation. In case of schema public, will look like this.

@Entity
@Table(schema=”public”, name = “user”)

2. By specifying the schema in the schema in the persistence.xml

This will crate a query that works:
select
user0_.id as id0_,
user0_.first_name as first2_0_,
user0_.last_name as last3_0_,
from
public.user user0_

Note that public.user

Thanks,
Not just a note to yourself, also to me.