[Yes You Can] Test SQL with Python and Friends

Testing SQL can be awkward. Let's talk about making it less so. This talk is a practical guide to testing SQL with Python. We'll cover testing with and without a live database, strategies for managing test environments, testing across SQL dialects, and automating code quality checks locally and in CI (Continuous Integration). You'll leave with concrete patterns and code examples that you can apply to your SQL pipelines. This talk is aimed at (1) Python developers who want to bring software engineering rigor to their SQL workflows and (2) SQL/data engineers looking to level up with Python-based testing tools and automation.