kayak/pypika
PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
License & maintenance
Apache-2.0 is a permissive license: free to use commercially with attribution.
Last code push 8 months ago.