latest--SqlAlchemy

shared
Type object
Schema URL https://catalog.lintel.tools/schemas/schemastore/eidolon-resource/_shared/latest--SqlAlchemy.json
Parent schema eidolon-resource
Type: object

A client for executing SQL queries using SQLAlchemy. See https://docs.sqlalchemy.org/ for connection configuration details.

Performs cursory checks when select_only is set to True. Additionally ensure user is restricted to allowed permissions.

Properties

implementation const: "SqlAlchemy" required
Constant: "SqlAlchemy"
protocol string
Default: null
connection_string string

SQLAlchemy connection string. See https://docs.sqlalchemy.org/en/20/core/engines.html for more information.

Default: "sqlite+aiosqlite:///:memory:"
engine_kwargs object
Default:
{}
select_only boolean
Default: false
metadata MetadataAttribute[]
Default:
[
  {
    "name": "tables",
    "metadata": [],
    "remove_falsy_metadata": true
  }
]

Definitions

MetadataAttribute object
name string required
metadata MetadataAttribute[] | string[]
Default:
[]
remove_falsy_metadata boolean
Default: true