tech debt: reference sql validation

[dogversioning]

CI should do the following so that our reference SQL is always up to date as a documentation reference:

• run generate-sql and ensure there are no changes
• execute sql against a database and ensure it's valid