How can i execute an actual `select star` query?
I want to write some CTEs. I used
db.select().from(table)
method, but it will generate an sql like select [...Columns] from table
. how can i modify it to actually get select * from table
in the generated sql?1 Reply
From the docs
Drizzle always explicitly lists columns in the select clause instead of using select *. This is required internally to guarantee the fields order in the query result, and is also generally considered a good practice.https://orm.drizzle.team/docs/select I imagine you could use the
sql
operator if you do need *
https://orm.drizzle.team/docs/sql