AI is Getting Really Useful for SQL

I’m using Google BigQuery to do some ETL, and have found OpenAI’s products to be enormously helpful for the task.

A new client recently asked for some assistance working with Sunshine Act data. Since I expect additional asks about this data set to come in over time, rather than fuss with the generic UI, I decided to load the entire dataset into BigQuery instead. ChatGPT’s o3-mini-high model has generated schemas and ETL queries extremely well, accelerating my work by at least a factor of 2x.

Continue reading “AI is Getting Really Useful for SQL”