dependabot[bot] opened a new pull request, #72: URL: https://github.com/apache/fineract-business-intelligence/pull/72
Updates the requirements on [sqlfluff](https://github.com/sqlfluff/sqlfluff) to permit the latest version. <details> <summary>Release notes</summary> <p><em>Sourced from <a href="https://github.com/sqlfluff/sqlfluff/releases";>sqlfluff's releases</a>.</em></p> <blockquote> <h2>[4.3.0] - 2026-08-07</h2> <h2>Highlights</h2> <p>This minor release brings expanded BigQuery pipe-syntax support, a wave of ClickHouse grammar additions, a new rule, and continued progress on the Rust-backed parsing engine.</p> <ul> <li>BigQuery pipe syntax (<code>|></code>) is now modelled natively as a postfix operation on selectables, so pipe queries can follow a <code>WITH</code> clause, use <code>EXCEPT</code>/<code>REPLACE</code> after a wildcard, and get correct indentation for <code>AGGREGATE</code>/<code>EXTEND</code> clauses.</li> <li>ClickHouse gains support for <code>TRUNCATE TABLES</code>/<code>TRUNCATE DATABASE</code>, <code>EXCHANGE</code>, the <code>REGEXP</code> operator, <code>GROUP BY WITH ROLLUP/CUBE/TOTALS</code>, multi-column <code>LIMIT BY</code>, and <code>ORDER BY ... WITH FILL ... INTERPOLATE</code>, among other additions.</li> <li>A new rule, <code>RF07</code>, flags window-clause references that shadow a <code>SELECT</code> alias.</li> <li><code>lint</code>, <code>fix</code>, and <code>format</code> all gain a consistent <code>--quiet</code> output mode.</li> <li>This release introduces the first Rust-native lint rule detection (<code>CP01</code>, <code>CP03</code>, <code>CP04</code>), extending the Rust engine beyond parsing and into linting for the first time — a major step toward our broader performance goals. Alongside this, numerous parity fixes (bracket matching, error messages, cache invalidation) keep the Rust and Python engines in sync.</li> </ul> <p>Beyond that, there are parser improvements across Oracle, PostgreSQL, Snowflake, Databricks, T-SQL, MySQL/MariaDB, Teradata, Athena, DuckDB, SQLite, Impala, and SparkSQL, plus rule fixes that remove false positives from <code>RF01</code>-<code>RF03</code>, <code>AL05</code>, <code>AM04</code>, <code>CV10</code>, <code>CV12</code>, <code>ST06</code>, <code>ST07</code>, and <code>PG01</code>.</p> <p>This release also includes first-time contributions from <strong>forty-seven</strong> new contributors. Thank you all for your contributions. 🏆</p> <h2>What’s Changed</h2> <ul> <li>fix(rust): avoid double allocation in pyo3 getters for collection fields (trim/type/escape) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8247";>#8247</a>) <a href="https://github.com/rubytobi";><code>@​rubytobi</code></a></li> <li>fix(rust): match Rust parser bracket matching to Python's behaviour on crossed, unclosed, and dialect-specific brackets (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8243";>#8243</a>) <a href="https://github.com/rubytobi";><code>@​rubytobi</code></a></li> <li>fix: pass sync=True to GhApi in release script (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8281";>#8281</a>) <a href="https://github.com/alanmcruickshank";><code>@​alanmcruickshank</code></a></li> <li>feat(clickhouse): add support for <code>TRUNCATE TABLES</code> statement (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8279";>#8279</a>) <a href="https://github.com/AndrewKurg";><code>@​AndrewKurg</code></a></li> <li>Allows %TYPE column type references in TABLE returns for functions in Postgres (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8269";>#8269</a>) <a href="https://github.com/KuttKatrea";><code>@​KuttKatrea</code></a></li> <li>test(ST06): pin reordering of a qualified reference with a parameterised cast (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8276";>#8276</a>) <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>fix: auto-detect cached_property names and invalidate on pos_marker change (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8274";>#8274</a>) <a href="https://github.com/JoeJoeflyn";><code>@​JoeJoeflyn</code></a></li> <li>Db2: parse COMMENT ON, multi-grantee GRANT and view WITH [NO] ROW MOVEMENT (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8262";>#8262</a>) <a href="https://github.com/davidpavlovschi";><code>@​davidpavlovschi</code></a></li> <li>CV12: don't fix join conditions when the join clause is templated (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8255";>#8255</a>) <a href="https://github.com/devanshranjan10";><code>@​devanshranjan10</code></a></li> <li>Support quiet output across lint, fix, and format (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8258";>#8258</a>) <a href="https://github.com/TrapsterDK";><code>@​TrapsterDK</code></a></li> <li>Fix Oracle SELECT INTO record field parsing (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8252";>#8252</a>) <a href="https://github.com/subotac";><code>@​subotac</code></a></li> <li>fix(ST02): preserve indexed expressions in NULL simplification (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8202";>#8202</a>) <a href="https://github.com/dev-willbird1936";><code>@​dev-willbird1936</code></a></li> <li>fix(sparksql): allow expression values in SET statements (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8187";>#8187</a>) <a href="https://github.com/Otto-Deviant1904";><code>@​Otto-Deviant1904</code></a></li> <li>Parse round-bracketed MAP types in Athena (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8246";>#8246</a>) <a href="https://github.com/davidpavlovschi";><code>@​davidpavlovschi</code></a></li> <li>Fix AL01 loop on bracketed column aliases (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8245";>#8245</a>) <a href="https://github.com/davidpavlovschi";><code>@​davidpavlovschi</code></a></li> <li>Snowflake: parse ADAPTIVE refresh mode, INITIALIZATION_WAREHOUSE, and streams on dynamic tables (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8241";>#8241</a>) <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>test(ST11): pin the UNNEST + deeply nested struct case from <a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/6997";>#6997</a> (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8240";>#8240</a>) <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>fix(rust): lexer/parser divergences in trim_chars inheritance and escape_replacements handling (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8224";>#8224</a>) <a href="https://github.com/rubytobi";><code>@​rubytobi</code></a></li> <li>fix(rust): match Python's parse-error message text (Sequence wording, token class/repr, grammar repr truncation) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8225";>#8225</a>) <a href="https://github.com/rubytobi";><code>@​rubytobi</code></a></li> <li>duckdb: parse USING SAMPLE / TABLESAMPLE (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8229";>#8229</a>) <a href="https://github.com/hdimer";><code>@​hdimer</code></a></li> <li>ST07: don't fix when a USING column is referenced unqualified (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8175";>#8175</a>) <a href="https://github.com/vidigoat";><code>@​vidigoat</code></a></li> <li>feat(clickhouse): add support for REGEXP operator (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8235";>#8235</a>) <a href="https://github.com/AndrewKurg";><code>@​AndrewKurg</code></a></li> <li>BigQuery: parse EXCEPT/REPLACE after a wildcard on an array element (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8194";>#8194</a>) <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>CV10: don't corrupt string literals that use quote-doubling escapes (fixes <a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8179";>#8179</a>) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8193";>#8193</a>) <a href="https://github.com/rahul188";><code>@​rahul188</code></a></li> <li>perf(rust): frame-free terminal evaluation (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8168";>#8168</a>) <a href="https://github.com/rubytobi";><code>@​rubytobi</code></a></li> <li>fix(dialects/oracle): support positional substitution variables (&1, &&1) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8233";>#8233</a>) <a href="https://github.com/felipeatom";><code>@​felipeatom</code></a></li> <li>rust(fix): Resolve two codegen-determinism hazards (id-cache collisions and unsorted currency-symbol regex) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8226";>#8226</a>) <a href="https://github.com/rubytobi";><code>@​rubytobi</code></a></li> <li>Databricks: config to stop ST12 flagging command cell delimiters as consecutive terminators (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8197";>#8197</a>) <a href="https://github.com/tsedeus";><code>@​tsedeus</code></a></li> <li>feat(clickhouse): add support for EXCHANGE statement (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8221";>#8221</a>) <a href="https://github.com/AndrewKurg";><code>@​AndrewKurg</code></a></li> <li>Impala: add support for VALUES aliases (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8185";>#8185</a>) <a href="https://github.com/strang3nt";><code>@​strang3nt</code></a></li> <li>feat(clickhouse): add support for <code>TRUNCATE DATABASE</code> (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8228";>#8228</a>) <a href="https://github.com/AndrewKurg";><code>@​AndrewKurg</code></a></li> <li>fix(dialects/postgres): parse MERGE ... WHEN NOT MATCHED BY SOURCE/TARGET (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8216";>#8216</a>) <a href="https://github.com/hdimer";><code>@​hdimer</code></a></li> <li>Postgres: stop LT01 spacing array types like <code>int []</code> (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8222";>#8222</a>) <a href="https://github.com/apoorva-01";><code>@​apoorva-01</code></a></li> </ul> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Changelog</summary> <p><em>Sourced from <a href="https://github.com/sqlfluff/sqlfluff/blob/main/CHANGELOG.md";>sqlfluff's changelog</a>.</em></p> <blockquote> <h2>[4.3.0] - 2026-08-05</h2> <h2>Highlights</h2> <p>This minor release brings expanded BigQuery pipe-syntax support, a wave of ClickHouse grammar additions, a new rule, and continued progress on the Rust-backed parsing engine.</p> <ul> <li>BigQuery pipe syntax (<code>|></code>) is now modelled natively as a postfix operation on selectables, so pipe queries can follow a <code>WITH</code> clause, use <code>EXCEPT</code>/<code>REPLACE</code> after a wildcard, and get correct indentation for <code>AGGREGATE</code>/<code>EXTEND</code> clauses.</li> <li>ClickHouse gains support for <code>TRUNCATE TABLES</code>/<code>TRUNCATE DATABASE</code>, <code>EXCHANGE</code>, the <code>REGEXP</code> operator, <code>GROUP BY WITH ROLLUP/CUBE/TOTALS</code>, multi-column <code>LIMIT BY</code>, and <code>ORDER BY ... WITH FILL ... INTERPOLATE</code>, among other additions.</li> <li>A new rule, <code>RF07</code>, flags window-clause references that shadow a <code>SELECT</code> alias.</li> <li><code>lint</code>, <code>fix</code>, and <code>format</code> all gain a consistent <code>--quiet</code> output mode.</li> <li>This release introduces the first Rust-native lint rule detection (<code>CP01</code>, <code>CP03</code>, <code>CP04</code>), extending the Rust engine beyond parsing and into linting for the first time — a major step toward our broader performance goals. Alongside this, numerous parity fixes (bracket matching, error messages, cache invalidation) keep the Rust and Python engines in sync.</li> </ul> <p>Beyond that, there are parser improvements across Oracle, PostgreSQL, Snowflake, Databricks, T-SQL, MySQL/MariaDB, Teradata, Athena, DuckDB, SQLite, Impala, and SparkSQL, plus rule fixes that remove false positives from <code>RF01</code>-<code>RF03</code>, <code>AL05</code>, <code>AM04</code>, <code>CV10</code>, <code>CV12</code>, <code>ST06</code>, <code>ST07</code>, and <code>PG01</code>.</p> <p>This release also includes first-time contributions from <strong>forty-seven</strong> new contributors. Thank you all for your contributions. 🏆</p> <h2>What’s Changed</h2> <ul> <li>fix(rust): avoid double allocation in pyo3 getters for collection fields (trim/type/escape) <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8247";>#8247</a> <a href="https://github.com/rubytobi";><code>@​rubytobi</code></a></li> <li>fix(rust): match Rust parser bracket matching to Python's behaviour on crossed, unclosed, and dialect-specific brackets <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8243";>#8243</a> <a href="https://github.com/rubytobi";><code>@​rubytobi</code></a></li> <li>fix: pass sync=True to GhApi in release script <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8281";>#8281</a> <a href="https://github.com/alanmcruickshank";><code>@​alanmcruickshank</code></a></li> <li>feat(clickhouse): add support for <code>TRUNCATE TABLES</code> statement <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8279";>#8279</a> <a href="https://github.com/AndrewKurg";><code>@​AndrewKurg</code></a></li> <li>Allows %TYPE column type references in TABLE returns for functions in Postgres <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8269";>#8269</a> <a href="https://github.com/KuttKatrea";><code>@​KuttKatrea</code></a></li> <li>test(ST06): pin reordering of a qualified reference with a parameterised cast <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8276";>#8276</a> <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>fix: auto-detect cached_property names and invalidate on pos_marker change <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8274";>#8274</a> <a href="https://github.com/JoeJoeflyn";><code>@​JoeJoeflyn</code></a></li> <li>Db2: parse COMMENT ON, multi-grantee GRANT and view WITH [NO] ROW MOVEMENT <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8262";>#8262</a> <a href="https://github.com/davidpavlovschi";><code>@​davidpavlovschi</code></a></li> <li>CV12: don't fix join conditions when the join clause is templated <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8255";>#8255</a> <a href="https://github.com/devanshranjan10";><code>@​devanshranjan10</code></a></li> <li>Support quiet output across lint, fix, and format <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8258";>#8258</a> <a href="https://github.com/TrapsterDK";><code>@​TrapsterDK</code></a></li> <li>Fix Oracle SELECT INTO record field parsing <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8252";>#8252</a> <a href="https://github.com/subotac";><code>@​subotac</code></a></li> <li>fix(ST02): preserve indexed expressions in NULL simplification <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8202";>#8202</a> <a href="https://github.com/dev-willbird1936";><code>@​dev-willbird1936</code></a></li> <li>fix(sparksql): allow expression values in SET statements <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8187";>#8187</a> <a href="https://github.com/Otto-Deviant1904";><code>@​Otto-Deviant1904</code></a></li> <li>Parse round-bracketed MAP types in Athena <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8246";>#8246</a> <a href="https://github.com/davidpavlovschi";><code>@​davidpavlovschi</code></a></li> </ul> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/8108cc202d2aa2732b21d48507152c95ee244030";><code>8108cc2</code></a> Prep version 4.3.0 (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8284";>#8284</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/a5ad86d82682ebae69a9effcfef2b34e3ef0960a";><code>a5ad86d</code></a> fix(rust): avoid double allocation in pyo3 getters for collection fields (tri...</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/a08ffaae54a775e20f205d46b1b2889efeedb261";><code>a08ffaa</code></a> fix(rust): match Rust parser bracket matching to Python's behaviour on crosse...</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/1913b2e293da06c26a202947dbaa66b5150875f3";><code>1913b2e</code></a> fix: pass sync=True to GhApi in release script (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8281";>#8281</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/de2da0309fe6fd178dbd4f7819346d872c35a0ff";><code>de2da03</code></a> feat(clickhouse): add support for <code>TRUNCATE TABLES</code> statement (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8279";>#8279</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/7a81f6eabe44475f2b7f3f06e7d9095e82a911e2";><code>7a81f6e</code></a> Allows %TYPE column type references in TABLE returns for functions in Postgre...</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/36c78988dafa72fdee5df77254dd5ac869e07e8d";><code>36c7898</code></a> test(ST06): pin reordering of a qualified reference with a parameterised cast...</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/86cb393c2899d7809fc19f4d2f8512b19e0c7025";><code>86cb393</code></a> fix: auto-detect cached_property names and invalidate on pos_marker change (#...</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/8d0e6496d4b54d9f6d22fb7b446e6aa74db3f068";><code>8d0e649</code></a> Db2: parse COMMENT ON, multi-grantee GRANT and view WITH [NO] ROW MOVEMENT (#...</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/d83768d6f1c84c1c95dbe8d9ac519bcc6bb9a806";><code>d83768d</code></a> CV12: don't fix join conditions when the join clause is templated (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8255";>#8255</a>)</li> <li>Additional commits viewable in <a href="https://github.com/sqlfluff/sqlfluff/compare/3.0.0...4.3.0";>compare view</a></li> </ul> </details> <br /> Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`. [//]: # (dependabot-automerge-start) [//]: # (dependabot-automerge-end) --- <details> <summary>Dependabot commands and options</summary> <br /> You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot show <dependency name> ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) </details> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
