You can create this as a view and use the SDK to retrieve that view

I am querying from my Express app and I want to run the above query using JS SDK. What do you mean by view?

If you are passing a parameter you will have to use a database function to do such a query as views don't take variables from what I can remember. Take a look at https://www.postgresqltutorial.com/postgresql-create-function/ for more information on how Postgres functions work.

Thanks, I"ll checkout. I tried this and it's working but I am not sure if this is good thing to do:

js
const userId = "1234"

const {data} = supabase.from("comments").select(`
  *
  WHERE post_id IN (
    SELECT post_id FROM posts WHERE user_id = ${userId}
  )
`)

Yes, but make sure you go through the guide I posted above on Postgres create function

Sure I am reading that atm. Can you please confirm if the current query using JS SDK above is not ideal to do?

Personally I wouldn't do it, I'm actually not even sure how that query is even working, the SDK shouldn't allow raw SQL to work as this can lead to malicious actions by a user, what I mean is if the

userId

is accessible to the user, they could change it to something like

"1234"; SELECT * FROM posts;

and this is a harmless query but people could possible drop tables with that sort of access too.

*from a server (not client)

You cannot do that using the SDK, its a security issue to allow such a feature.

not even from my server? That's sad 😦

You can connect to the database directly using a postgres library and then run your queries like that.

That sounds promising, let me look for one

It doesn't matter, its a security risk through the SDK.

Yeah that will work, I use this one https://github.com/porsager/postgres#readme

Thanks

Thats a completely different query, no where clauses inside of the select

oh ok

Also note the cities there is representing a relationship