You can select arbitrary expression including subqueries and raw sql snippets.
When you do that, you need to give a name for the selections using the
The API documentation is packed with examples. The API docs are hosted here but you can access the same documentation by hovering over functions/methods/classes in your IDE. The examples are always just one hover away!
For example, check out these sections: