> ## Documentation Index
> Fetch the complete documentation index at: https://docs.parable.work/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Behavior

> Understand Parable's naming, Arrow types, logical relationships, and read-only query contract.

Parable serves read-only SQL through Apache DataFusion and Arrow Flight SQL.
The same query behavior applies across TypeScript, Python, Go, Rust, JDBC, ADBC,
and other compatible clients.

<Columns cols={2}>
  <Card title="Fully qualified names" icon="quote-right" href="/protocols/sql/sql-behavior/fully-qualified-names">
    Address pools, schemas, tables, flattened fields, and child tables.
  </Card>

  <Card title="Types and metadata" icon="shapes" href="/protocols/sql/sql-behavior/types-and-metadata">
    Read Arrow types, semantic scalars, and catalog annotations.
  </Card>

  <Card title="Keys and relationships" icon="diagram-project" href="/protocols/sql/sql-behavior/keys-and-relationships">
    Discover logical primary keys, foreign keys, and safe joins.
  </Card>

  <Card title="Supported operations" icon="list-check" href="/protocols/sql/sql-behavior/supported-operations">
    Check statements, prepared statements, metadata, and unsupported commands.
  </Card>
</Columns>

## Core guarantees

* Queries are scoped to the Workspace selected by request metadata.
* Query execution is read-only.
* Results stream as Arrow record batches.
* Catalog metadata describes logical keys and semantic types without enforcing
  database constraints.
* Clients can negotiate the supported subset through Flight SQL capability
  metadata.

Start with [Query with SDKs](/protocols/sql/query-with-sdks) for a working
connection or [Flight SQL](/protocols/sql/flight-sql) for the transport-level
contract.