Epic 17 (R1 Documentation & Marketing), Story 17.6 — Layer 0. MD mirror of the canonical web Known Limitations & Roadmap page (softclient4es-web issue #15).
Dual-docs-sync deliverable: the plain-Markdown mirror of the customer-facing page that states exactly which SQL works in R1, which does not, when the gaps close (R2a/R2b/R3+), and the per-tool BI workaround.
Changes (elasticsql, base release-r1):
- NEW
documentation/sql/known_limitations.md ([Back to index](README.md) + # Known Limitations & Roadmap H1)
- UPDATE
documentation/sql/README.md — index link after DQL Support
- Inbound one-liner "Known limitations" links on
documentation/sql/dql_statements.md and documentation/client/arrow_flight_sql.md
Token-for-token parity with the web MDX. Every "works"/"does NOT work" claim verified against origin/release-r1 parser source (JOIN 5 types, UNION ALL token only, IN-literal-only, Exists commented, all 8 WITH non-CTE, NTILE/LAG/LEAD zero hits, EXCEPT-is-projection-not-set-op, Epic-14 functions present). Outbound links to joins.md (17.1) and ../client/federation_operator_guide.md (16.6/17.2) forward-declared (targets not on release-r1 yet).
🤖 Generated with Claude Code
Epic 17 (R1 Documentation & Marketing), Story 17.6 — Layer 0. MD mirror of the canonical web Known Limitations & Roadmap page (softclient4es-web issue #15).
Dual-docs-sync deliverable: the plain-Markdown mirror of the customer-facing page that states exactly which SQL works in R1, which does not, when the gaps close (R2a/R2b/R3+), and the per-tool BI workaround.
Changes (elasticsql, base
release-r1):documentation/sql/known_limitations.md([Back to index](README.md)+# Known Limitations & RoadmapH1)documentation/sql/README.md— index link after DQL Supportdocumentation/sql/dql_statements.mdanddocumentation/client/arrow_flight_sql.mdToken-for-token parity with the web MDX. Every "works"/"does NOT work" claim verified against
origin/release-r1parser source (JOIN 5 types, UNION ALL token only, IN-literal-only, Exists commented, all 8 WITH non-CTE, NTILE/LAG/LEAD zero hits, EXCEPT-is-projection-not-set-op, Epic-14 functions present). Outbound links tojoins.md(17.1) and../client/federation_operator_guide.md(16.6/17.2) forward-declared (targets not onrelease-r1yet).🤖 Generated with Claude Code