If the model you are querying has a column with the attribute @DeleteDateColumn set, the query builder will automatically query rows which…

QueryBuilder instances support common table expressions , if minimal supported version of your database supports them. Common table expressions aren’t supported for Oracle…

You can get the generated SQL from the query builder by calling getQuery() or getQueryAndParameters(). If you just want the query you can…