how to use a POSTGIS function in a .select()

Hi all !
I 've tried supabase for a new project and it looks great.
I'm trying to do something like this :
await supabase
.from("items")
.select(
id, title, body, ST_X(location), ST_Y(location)
)


but it seems like it does not work. Is there a special way to do that or should I use RPC ?
Thanks in advance for your help
Was this page helpful?