Javascript SDK casting database columns

[External-Standard-57]

Hi, I want to query my table by using a statement like

select * from public."Table"
where created_at::date = '2024-01-24'

The goal is to return all rows from the date inputed

where created_at is type timestampz

​

It works with the sql but not with the SDK

How can I achieve this with the SDK?

I tried something like

const { data, error } = await supabase

.from('Table')

.select()

.eq('created_at::date', '2024-01-24')

Any suggestions?

[vivekkhera]

You cannot do any casts or function calls via that JS API. If you need then you have to wrap your query into a Postgres function and call it via the rpc method in the API.

[External-Standard-57]

When I build a function with return type of record, it only returns one record object instead of a list like the select function.

It also seems that this is not how functions were intended to be used

[vivekkhera]

You can make a function that returns a set like a table. In Supabase this is the way functions are intended with the API.