Description: 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.
1. Property implementation
Title: Implementation
Specific value: "SqlAlchemy"
2. Property protocol
Title: Protocol
| |
|---|
| Type | string |
| Required | No |
| Default | null |
3. Property connection_string
Title: Connection String
| |
|---|
| Type | string |
| Required | No |
| Default | "sqlite+aiosqlite:///:memory:" |
Description: SQLAlchemy connection string. See https://docs.sqlalchemy.org/en/20/core/engines.html for more information.
4. Property engine_kwargs
Title: Engine Kwargs
5. Property select_only
Title: Select Only
| |
|---|
| Type | boolean |
| Required | No |
| Default | false |
Title: Metadata
| |
|---|
| Type | array |
| Required | No |
| Default | [{"name": "tables", "metadata": [], "remove_falsy_metadata": true}] |
| Array restrictions |
|---|
| Min items | N/A |
| Max items | N/A |
| Items unicity | False |
| Additional items | False |
| Tuple validation | See below |
| |
|---|
| Type | object |
| Required | No |
| Additional properties | [Any type: allowed] |
| Defined in | #/$defs/MetadataAttribute |
| Property | Pattern | Type | Deprecated | Definition | Title/Description |
|---|
| + name | No | string | No | - | Name |
| - metadata | No | Combination | No | - | Metadata |
| - remove_falsy_metadata | No | boolean | No | - | Remove Falsy Metadata |
6.1.1. Property name
Title: Name
Title: Metadata
6.1.2.1. Property item 0
| Array restrictions |
|---|
| Min items | N/A |
| Max items | N/A |
| Items unicity | False |
| Additional items | False |
| Tuple validation | See below |
6.1.2.2. Property item 1
| |
|---|
| Type | array of string |
| Required | No |
| Array restrictions |
|---|
| Min items | N/A |
| Max items | N/A |
| Items unicity | False |
| Additional items | False |
| Tuple validation | See below |
6.1.2.2.1. item 1 items
Title: Remove Falsy Metadata
| |
|---|
| Type | boolean |
| Required | No |
| Default | true |
