Everything is ok when running in designer , but it will throw exception in client.
Check your privileges configured in the project settings. You might need to allow legacy database access for the client to be able to run queries that aren’t inside a Named Query
3 Likes