How do I use the sql operator with better-sqlite3?
Hello. I'm trying to build a custom query with the sql operator in drizzle-orm, and to run it against my sqlite db using the better-sqlite3 driver.
However, the better-sqlite3 driver apparently doesn't have a db.execute method, which is how the docs execute custom queries with the sql operator. Please could anyone help me with this?
1 Reply
Ok, I figured it out, you can execute it by passing the sql as an argument to the db.all() function. Like, "db.all(sqlquery)".