mixle.data.sources.sql_source module

SQL connector – any SQLAlchemy URL (Postgres / MySQL / SQLite / …) into a DataSource.

Optional: requires sqlalchemy (pip install mixle[sql]). One connector covers every RDBMS; rows stream from a server-side cursor so a large result set is not fully materialized in the driver.

read_sql(url, query, columns=None, *, structure=EXCHANGEABLE, schema=None)

Read the rows of query against the database at url into a lazy DataSource.

Parameters:

• url (str)

• query (str)

• columns (list[str] | None)

• structure (SampleStructure)

• schema (Schema | None)

Return type:

LazySource