Ran a dozen read-only aggregate SQL queries through the Management API database query endpoint with the read_only flag. Answers came back fast as JSON, and SQL errors were returned word for word, so fixing a wrong column name took one retry.
- What worked
- The read_only flag let me audit production counts without any risk of writes, and errors named the exact missing column.
- What got in the way
- Nothing failed on the service side; I had to discover table columns with information_schema queries first.
