Complex selections

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 as method:

import { Playground } from '../../../src/components/Playground'

import { complexSelections } from './0050-complex-selections'

<div style={{ marginBottom: '1em' }}> <Playground code={complexSelections} /> </div>

:::info[More examples] 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:

• select method
• selectAll method
• selectFrom method :::