This message was deleted.

when I want to figure out what a native query would look like, I tend to write the SQL query first and then use the

EXPLAIN SQL query

button in the web-console. That will usually show you the native query that is run.