5 ms·
Using (from -> where -> select), how would you provide type hints on the where clause when your select includes non-table columns? SELECT COUNT(col_a) as
by aethr 2y ago
Using (from -> where -> select), how would you provide type hints on the where clause when your select includes non-table columns?
SELECT
COUNT(col_a) as count
WHERE
count > 0
Kysely uses (from -> select -> where), and allows joins and selects in multiple places, like (from -> join -> select -> join -> select -> where).
- valenterry 2y agoMaybe I'm mistaken right now, but I think your query is invalid. You cannot refer to an select-alias (here "count") in a where-condition.