What this does

This runs sqlc vet using our queries and schema for a given commit. The only sql lint rule we currently have is that a query can be prepared against our schema.

This protects us from writing a migration that breaks an existing query, or writing a new query that will not execute.

We unit test almost all of our queries, so this failure will likely be caught in test-go-pg. However, the reported failure will correspond to some number of Go tests, and the output might not be straight forward. sqlc vet will have clearer reporting and easier debugging.

Example

Found a query that does not work: (https://github.com/coder/coder/actions/runs/7186260845/job/19574288356)

--- sqlc vet
# package 
queries/tailnet.sql:101:8: column "tailnet_clients.id" must appear in the GROUP BY clause or be used in an aggregate function