import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/deps.ts";
const { QueryCreator } = kysely;
Creates a select
query builder without a from
clause.
If you want to create a select from
query, use the selectFrom
method instead.
This one can be used to create a plain select
statement without a from
clause.
This method accepts the same inputs as {@link SelectQueryBuilder.select}. See its documentation for more examples.
Examples
const result = db.selectNoFrom((eb) => [
eb.selectFrom('person')
.select('id')
.where('first_name', '=', 'Jennifer')
.limit(1)
.as('jennifer_id'),
eb.selectFrom('pet')
.select('id')
.where('name', '=', 'Doggo')
.limit(1)
.as('doggo_id')
])
.executeTakeFirstOrThrow()
console.log(result.jennifer_id)
console.log(result.doggo_id)
The generated SQL (PostgreSQL):
select (
select "id"
from "person"
where "first_name" = $1
limit $2
) as "jennifer_id", (
select "id"
from "pet"
where "name" = $3
limit $4
) as "doggo_id"
Type Parameters
SE extends SelectExpression<DB, never>
Parameters
selections: ReadonlyArray<SE>
Returns
SelectQueryBuilder<DB, never, Selection<DB, never, SE>>
Type Parameters
CB extends SelectCallback<DB, never>
Parameters
callback: CB
Returns
SelectQueryBuilder<DB, never, CallbackSelection<DB, never, CB>>
Type Parameters
SE extends SelectExpression<DB, never>
Parameters
selection: SE
Returns
SelectQueryBuilder<DB, never, Selection<DB, never, SE>>