pugsql
pugsql copied to clipboard
A HugSQL-inspired database library for Python
It'd be nice to include the function names and filenames in the sql queries that wind up getting run, i.e. the database should see something like: ```sql -- pugsql function...
HugSQL supports `:doc`, e.g. ```sql -- :name foo -- :doc This string documents the resulting function select 1; ``` Ideally we'd support this and it'd be displayed when using `help()`...
This should either work or break more gracefully. Explanation here: https://github.com/mcfunley/pugsql/pull/12
Can the return value be of type `OrderedDict` instead of `dict`, so that the return value corresponds to the column order in SQL one by one?