Automatic CRUD

[tvallotton]

Look into configuring automatic CRUD queries for models. It could generate read/delete/update methods for each unique key in the model, and include both an insert and update query.

Example

codegen:
  crud:
    include: .* # accepts a regex pattern
    exclude:
      - audit_logs

Generated methods for each model:

• get_by_<unique key>
• delete_by_<unique key>
• update_by_<unique key>
• upsert
• insert

Btw, this should also probably include bulk inserts, since this is an area where one must usually implement them with json, which removes much of the type safety benefits of pgc.
It is unclear to me if update_by_<unique key> is ever going to be useful given the existence of upsert.

[tvallotton]

I think the namespacing could default to:

queries.<schema_name>.<table_name>.<method_name>

And for bulk operations it could be:

queries.<schema_name>.<table_name>.bulk.<method_name>