3 ms·
Don't see any support for CTEs, window functions or joins. Admittedly joins should probably be handled as views, but window functions and CTEs can be very usefu
by SJC_Hacker 2y ago
Don't see any support for CTEs, window functions or joins. Admittedly joins should probably be handled as views, but window functions and CTEs can be very useful in some circumstances.
It does seem like for basic CRUD this should be all you need. But you will probably run into situations where it can't handle something, and then you have to write your own endpoints anyway.
Writing your own endpoints also allows more flexibility if yu want to do some post/pre-processing steps.
- fzeindl 2y ago> Don't see any support for CTEs, window functions or joins. Admittedly joins should probably be handled as views, but window functions and CTEs can be very useful in some circumstances. They can be used in a view that is then exposed. Parameterized functions for more complex queries can also be exposed.
- dventimi 2y agoJoins are supported: https://postgrest.org/en/v12/references/api/resource_embedding.html#foreign-key-joins https://postgrest.org/en/v12/references/api/resource_embeddi...