SQL is code. Write it, version control it, comment it, and run it using files.
Writing your SQL code in Python programs as strings doesn't allow you to easily
reuse them in SQL GUIs or CLI tools like psql. With aiosql you can organize
your SQL statements in .sql files, load them into your python application as
methods to call without losing the ability to use them as you would any other
SQL file.
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above. NOTE: This is a Python port. Instead of py311-aiosql listed in the above command, you can pick from the names under the Packages section.
databases/py-aiosql: Update to 13.4
- Add a patch to fix build that would otherwise fail with the error:
===> Building for py311-aiosql-13.4
* Getting build dependencies for wheel...
[06/13/25 10:43:25] WARNING pyproject.toml does not contain a
tool.setuptools_scm section
setuptools.py:119
/usr/local/lib/python3.11/site-packages/setuptools/config/pyprojecttoml.py:104:
_BetaConfiguration: Support for `[tool.setuptools]` in `pyproject.toml` is still
*beta*.
warnings.warn(msg, _BetaConfiguration)
configuration error: `project.license` must be valid exactly by one definition
(2 matches found):
- keys:
'file': {type: string}
required: ['file']
- keys:
'text': {type: string}
required: ['text']
Reported by: portscout!
databases/py-aiosql: Add new port
SQL is code. Write it, version control it, comment it, and run it using files.
Writing your SQL code in Python programs as strings doesn't allow you to easily
reuse them in SQL GUIs or CLI tools like psql. With aiosql you can organize
your SQL statements in .sql files, load them into your python application as
methods to call without losing the ability to use them as you would any other
SQL file.
https://pypi.org/project/aiosql/
