René's URL Explorer Experiment

Title: consume any-sdk v0.5.3-alpha08 (casing + schema_driven_xml) + robot coverage by jeffreyaven · Pull Request #678 · stackql/stackql · GitHub

Open Graph Title: consume any-sdk v0.5.3-alpha08 (casing + schema_driven_xml) + robot coverage by jeffreyaven · Pull Request #678 · stackql/stackql

X Title: consume any-sdk v0.5.3-alpha08 (casing + schema_driven_xml) + robot coverage by jeffreyaven · Pull Request #678 · stackql/stackql

Description: Summary Consumes any-sdk v0.5.3-alpha08 and adds two user-facing capabilities plus functional coverage. Bumps github.com/stackql/any-sdk v0.5.3-alpha05 -> v0.5.3-alpha08 (PR 106 query-option push-down + pagination, PR 107 casing engine + schema_driven_xml). go build and the full go test ./... suite are green; golangci-lint (v2.5.0) reports no new issues. A new no-auth stackql_native_test provider + native_test flask mock (registry-rewrite default port 1070) back all new functional suites. Features OData query-option push-down (issue 659) Wires the public formulation.ApplyPushdown helper into the REST acquire path. A SELECT's projection / WHERE / ORDER BY / LIMIT / OFFSET / COUNT(*) are translated to $select/$filter/$orderby/$top/$skip/$count and merged onto the outgoing request: WHERE col = 'v' -> $filter=col eq 'v'; WHERE col LIKE 'A%' -> startswith(col,'A') (eq/ne/gt/ge/lt/le supported; AND-conjoined predicates combined; OR / non-prefix LIKE stay client-side residual). LIMIT/OFFSET -> $top/$skip; ORDER BY -> $orderby; explicit projection -> $select; COUNT(*) -> $count. Activated only when the method/resource carries a queryParamPushdown config, and only for single-table selects (a join could under-fetch). Push-down is an optimisation: stackql's client-side WHERE/projection/LIMIT remain authoritative, so a partial or absent translation cannot change results. Unblocks the entra_id provider. GraphQL completion (issue 677) --http.log.enabled now emits the GraphQL wire request + raw response (alpha08 graphql.ContextWithHTTPLogger), mirroring the REST acquire path. SQL LIMIT N is pushed into the GraphQL query variables as limit, so a query template referencing {{ .limit }} (e.g. first: {{ .limit }}) bounds the page size. Cursor pagination (any-sdk cursor_after) and response.transform already consume alpha08; GraphQL errors now surface instead of returning empty rows (auto-consumed). Tests internal/stackql/execution/odata_pushdown_test.go - 7 unit tests for AST -> intent (operators, LIKE->startswith, COUNT, SELECT *, join guard, OR residual). test/robot/functional/stackql_odata_pushdown.robot - 8 cases asserting each pushed OData option (the mock echoes the decoded query) and that client-side filtering remains authoritative. test/robot/functional/stackql_graphql_pagination.robot - 3 cases: multi-page cursor pagination, LIMIT -> first: 3 in the wire query (via --http.log.enabled), cursor follow. Plus the casing + schema_driven_xml suites from the first batch. Test plan go test -timeout 1200s --tags "sqlite_stackql" ./... - green, no regression. golangci-lint run - clean. python cicd/python/build.py --robot-test - new functional suites pass (21/21 locally). Known any-sdk gaps (tracked upstream, not blocking) snake_case_aliases multi-word value mapping and request.nativeCasing reverse-resolution are deferred to any-sdk (issues filed); the OData push-down test provider therefore uses wire-name columns.

Open Graph Description: Summary Consumes any-sdk v0.5.3-alpha08 and adds two user-facing capabilities plus functional coverage. Bumps github.com/stackql/any-sdk v0.5.3-alpha05 -> v0.5.3-alpha08 (PR 106 query-option pus...

X Description: Summary Consumes any-sdk v0.5.3-alpha08 and adds two user-facing capabilities plus functional coverage. Bumps github.com/stackql/any-sdk v0.5.3-alpha05 -> v0.5.3-alpha08 (PR 106 query-option...

Opengraph URL: https://github.com/stackql/stackql/pull/678

X: @github

direct link

Domain: github.com

Links:

Viewport: width=device-width