Select columns as NULL or as placeholder

[MaxosHadj]

Trying to do the following:

SELECT value_a, value_b, null AS c FROM table

or

SELECT value_a, value_b, 'myValue' AS c FROM table

I tried to use raw SQL without success

Any idea?

[igalklebanov]

Hey 👋

I tried to use raw SQL without success

You should provide the errors you're getting. Otherwise people can't help you.

sql template tag has the lit method for this use-case.

import { sql } from "kysely";

await db
  .selectFrom("table")
  .select([
    "value_a",
    "value_b",
    sql.lit(null).as("c"),
    sql.lit("myValue").as("d"),
  ])
  .execute();

https://kyse.link/qjh24

But be careful! to avoid SQL injection, you must validate strings passed to sql.lit.