Select query without from

[olee]

Hi, I would like to write a select query for later usage in a CTE which does not use a from clause.

For example something like this query, which takes in arguments and converts them to helper values for later filtering:

select
  $1 - INTERVAL '1 day' as "min_start",
  $2 as "max_start",
  $1 as "min_end",
  $2 + INTERVAL '1 day' as "max_end"

Is this possible in some way? Because as far as I can see, there is no way to call .select(...) without afterwards calling .from(...) as well.

[olee]

Ok, found a solution by using

db.select(...).from(sql`(select 1)`)