What is your workflow for developing, testing and versioning SQL queries?<p>My company has data pipelines that query a number of databases, such as MySQL and BigQuery. The SQL queries are typically read from a file or inlined as a string.<p>It seems to be challenging to develop, test and reuse SQL queries as you would code in programming languages like Python or Java.<p>For example, I'd like to decompose queries into reusable units that can be individually tested without heavy-weight external or remote dependencies and complicated setup, have any ideas?