I am on a point where I need to build some complex queries for a search/filter page on my app, where the supabase client nor a postgres functions suits the needs. I was thinking of connecting myself manually with a nodejs posgres library. Does anyone have recommendations other than

pg

?

PG functions can run any SQL you'd be able to run with a normal query. Is there something specific that you're unable to achieve with it? In terms of libraries, the

pg

library is a great option and I've had success with it. If you need to import data from a CSV, then

pg-copy-streams

is a great option too.

I have to make a queries with

SELECT EXTRACT

,

GROUP BY

and where conditions like this

WHERE something AND ((a AND b) OR c)