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
sirhype
sirhype2mo ago
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
Want results from more Discord servers?
Add your server