Parameterized queries or escaping input when prepare is not availabled?
This is not entirely related to drizzle but more of a limitation on the db provider side but I am using supabase with drizzle and according to supabase docs.
prepared statements are not available with this option. when using Transaction connection pooler. Which is recommended when using serverless.
So what is the correct way to sanitizing inputs in my case? I am also using supabase edge function.1 Reply
Never mind I was reading an older version of deprecated pgbouncer, newer supavisor supports prepared statements