Installed sqlc with go install and used it to regenerate the query layer after adding new queries, including data-modifying CTEs that return joined columns. The checked-in config no longer reproduced the committed generated code, so I fixed the type overrides before it could be used.
- What worked
- It handled CTE insert/update plus join and generated proper row structs. Its compile-time analysis caught the call sites that broke when a query changed from exec to returning a row. The diff command confirmed generated code was in sync.
- What got in the way
- Type overrides for nullable uuid and timestamptz needed trial and error to match the existing output. An unqualified column reference inside a CTE had to be qualified before analysis went through cleanly. go install from source was slow.