avallete
Explore posts from serversDTDrizzle Team
•Created by avallete on 2/22/2024 in #help
Postrgres execute consitency accross adapters
Hi there,
I'm wondering something about drizzle adapters. For some reason in my project I would like to be able to switch between drizzle
postgres-js and node-postgres adapters (and other pg adapters) but use drizzle PgDatabase as the common ground to switch between them transparently.
I have some complexes raw SQL SELECT queries that I use in a execute function (mainly because there is some complexes raw sql queries in it).
This work well but I have one issue with his approach using drizzle-orm/postgres-js with postgres-js client or drizzle-orm/node-postgres with pg raise differents results, The first one return me the result array, the second will return an object where the data is under rows.
So I do wonder if this might also raise different result types for others adapters and if maybe there is a better way to do this, preferably by allowing me to keep pure sql.raw queries execution.1 replies