PugSQL is a simple Python interface for using parameterized SQL, in files, with any SQLAlchemy-supported database. import pugsql # Create a module of database functions from a set of sql files on disk. queries = pugsql.module('resources/sql') # Point the module at your database. queries.connect('sqlite:///foo.db') # Invoke parameterized queries, receive dicts! user = queries.find_user(user_id=42)
![PugSQL :: SQL is Extremely Good, Actually](https://cdn-ak-scissors.b.st-hatena.com/image/square/104b5db9aa0b7756f41b50f63ffd92bd52161085/height=288;version=1;width=512/https%3A%2F%2Fpugsql.org%2Fassets%2Fimages%2Fog-image.jpg)