Query templates about sqlc HOT 3 CLOSED

IMHO, there are two aspects to this.

First is to DRY-up the SQL so the select expressions don't need to be repeated (and additionally kept consistent across queries). This obviously has implications, a big one being that the queries are no longer real.

Second is the ability to share the return types on the generated Go code side. By this I mean that if I have two queries with the same select expression, only generate one shared return type for them. Using some sort of hashing of the select expression and table name should be able to allow this independent of the first concern and would be a great improvement in itself. The question of what/how to name this type is not obvious though.

from sqlc.

An example of what this looks like for us are queries with computed columns. One real example is where a table has many columns and a single one with a prefix appended to it:

const columns = `
  concat('prefix_', id) as "id",
  type,
  account_id,
  created_at,
  description,
  metadata,
   ...

from sqlc.

I haven't made any progress on this design, so I'm going to close out this issue for now.

from sqlc.