Yes, the DDL example is not ideal... I'm looking to make a tutorial out of it for new PostgREST users that don't have a lot of experience with Postgres, so it's more verbose than it should be in a normal application. Let's see if I can dig up a more monstrous example with CTEs somewhere. And please let me know if you have something sufficiently convoluted at hand! :-)
It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
Yes, the DDL example is not ideal... I'm looking to make a tutorial out of it for new PostgREST users that don't have a lot of experience with Postgres, so it's more verbose than it should be in a normal application. Let's see if I can dig up a more monstrous example with CTEs somewhere. And please let me know if you have something sufficiently convoluted at hand! :-)
How's this?
Deliciously monstrous! Only missing some 'with recursive' to round it off :-)
Let's use that as an additional example! Thanks Dian.