Two questions about sync rule capabilities

[Lomacar]

Can sync rules query Postgres functions and can Powersync get the name of the table to sync from the AS clause of a query and not just the WHERE clause. The idea is to use a function to do a more sophisticated query than PS can normally handle, return a table that exactly matches the columns of a real table. And then in the sync rule SQL do something like SELECT * FROM my_function(bucket.project_id) AS "my_real_table_name".

[rkistner]

PowerSync does support table aliases using the AS clause - the aliased name will be used in the sync protocol and on the client.

However, we do not support any custom Postgres functions or views. Only physical Postgres tables can be replicated, and only the functions and operators listed here are supported. If there are specific additional column-level functions you need, please let us know and we can consider adding them.

[Lomacar]

Oh, even views aren't supported? Every AI I asked said they were, including the one on the PowerSync website.

[cahofmeyr]

Could you share the prompt that you used?

[Lomacar]

Hmm, well now I asked the AI on the website two different ways and it said no. I don't know how i worded it before.