Metadata-Version: 2.4
Name: dirigent-block-sql
Version: 0.17.0
Summary: The SQL block family for dirigent: sql.query, sql.execute, and the sql connection kind.
License-Expression: LicenseRef-Proprietary
License-File: LICENSE
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.13
Requires-Dist: dirigent-common==0.17.0
Requires-Dist: dirigent-plugin==0.17.0
Requires-Dist: sqlalchemy[asyncio]>=2.0.52
Requires-Python: >=3.13
Description-Content-Type: text/markdown

# dirigent-block-sql

The SQL block family: `sql.query` reads rows and `sql.execute` writes them, both against the
database a `sql` connection names.

The connection kind holds the URL and its credential, and the driver is SQLAlchemy's, so any
dialect with an async driver the worker has installed is addressable.

Engines are packages. A backend that needs more than a driver implements `SqlEngine` and
registers under the `dirigent.sql.engines.v1` entry-point group, and the family asks it what a
valid connection to that backend is, where a database written as a relative path lands, what a
parameter becomes, how a check reaches it, and what a session on it is.
`dirigent-block-duckdb` is the first, and `duckdb:///warehouse.duckdb` works once it is
installed.
