dependabot[bot] opened a new pull request, #100: URL: https://github.com/apache/fineract-business-intelligence/pull/100
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.4.0] - 2026-10-02</h2> <h2>Highlights</h2> <p>This minor release introduces SQLMesh integration, new linting and formatting options, and a refreshed documentation site, alongside a broad set of dialect improvements and bug fixes.</p> <ul> <li><strong>SQLMesh projects can now use SQLFluff through the new <code>sqlfluff-templater-sqlmesh</code> plugin.</strong> The optional templater brings SQLFluff linting to SQLMesh models, with support for model definitions and macro rendering.</li> <li><strong>Two recent rules offer additional opt-in conventions.</strong> <code>CV13</code> encourages a pure <code>SELECT * FROM <cte></code> passthrough as the final query in a CTE-based model, following the dbt convention. <code>TQ04</code> prefers <code>expression AS alias</code> over T-SQL's <code>alias = expression</code> syntax. Both are currently disabled by default and can be enabled with <code>force_enable = True</code>.</li> <li><strong>The CLI gains GitLab Code Quality output</strong> through <code>--format gitlab</code>, allowing findings to appear directly in GitLab merge requests. This joins the existing SARIF and GitHub annotation formats for integrating SQLFluff into CI.</li> <li><strong>The Jinja templater now supports custom delimiters</strong>, including the <code><% ... %></code> syntax used by Snowflake CLI. <code>LT15</code> also gains an optional minimum number of blank lines between statements.</li> <li><strong><a href="https://docs.sqlfluff.com";>docs.sqlfluff.com</a> has migrated to a new documentation format.</strong> The site is more responsive, easier to search, and supports dark mode, with a design that fits the rest of the SQLFluff project.</li> </ul> <p>Beyond that, this release expands parsing support across Snowflake, MariaDB/MySQL, ClickHouse, PostgreSQL, Oracle, Databricks, Flink, Athena, SQLite, Trino, and other dialects. Rule and templater fixes improve reliability, reduce false positives, and prevent unsafe autofixes.</p> <p>This release also includes first-time contributions from <strong>forty-three</strong> new contributors. Thank you all for your contributions. 🏆</p> <h2>What’s Changed</h2> <ul> <li>Make stable the default docs landing version (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8631";>#8631</a>) <a href="https://github.com/alanmcruickshank";><code>@​alanmcruickshank</code></a></li> <li>build(deps): bump github/issue-labeler from 3.4 to 3.5 in the github-actions group (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8618";>#8618</a>) <a href="https://github.com/apps/dependabot";><code>@​dependabot[bot]</code></a></li> <li>fix(AM02): preserve UNION's existing case instead of forcing a hardcoded one (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8534";>#8534</a>) <a href="https://github.com/udsy19";><code>@​udsy19</code></a></li> <li>Redshift: parse array accessors in SUPER paths in the FROM clause (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8526";>#8526</a>) <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>Prepare docs URL parity and production indexing (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8629";>#8629</a>) <a href="https://github.com/alanmcruickshank";><code>@​alanmcruickshank</code></a></li> <li>ci: fix mypy type annotation for "subclass" (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8621";>#8621</a>) <a href="https://github.com/keraion";><code>@​keraion</code></a></li> <li>docs: refine historical versions index (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8609";>#8609</a>) <a href="https://github.com/alanmcruickshank";><code>@​alanmcruickshank</code></a></li> <li>Databricks: support Unity Catalog volume privileges in GRANT and REVOKE (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8512";>#8512</a>) <a href="https://github.com/taslater";><code>@​taslater</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>fix(mysql): parse DO statements (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8582";>#8582</a>) <a href="https://github.com/rfanth";><code>@​rfanth</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>Oracle: allow DELETE without the optional FROM keyword (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8576";>#8576</a>) <a href="https://github.com/MrDKOz";><code>@​MrDKOz</code></a>, <a href="https://github.com/apps/cubic-dev-ai";><code>@​cubic-dev-ai[bot]</code></a></li> <li>StarRocks: support PARTITION BY LIST (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8555";>#8555</a>) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8595";>#8595</a>) <a href="https://github.com/mishra-prince";><code>@​mishra-prince</code></a></li> <li>feat(clickhouse): add support for projections (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8585";>#8585</a>) <a href="https://github.com/AndrewKurg";><code>@​AndrewKurg</code></a></li> <li>Hive/Impala: support the NULL-safe equals operator <code><=></code> (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8575";>#8575</a>) <a href="https://github.com/remilepriol";><code>@​remilepriol</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>fix(RF01): allow Trino ROW access for single table targets (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8475";>#8475</a>) <a href="https://github.com/dennisimoo";><code>@​dennisimoo</code></a></li> <li>Trino: support SHOW, DESCRIBE and EXPLAIN ANALYZE statements (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8540";>#8540</a>) <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>Snowflake: Support ROW_TIMESTAMP_DEFAULT and trailing commas in table column definitions (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8472";>#8472</a>) <a href="https://github.com/itzzdev09";><code>@​itzzdev09</code></a></li> <li>Postgres: support SET ACCESS METHOD on tables and materialized views (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8436";>#8436</a>) <a href="https://github.com/Mynk11";><code>@​Mynk11</code></a></li> <li>Apply an inner .sqlfluffignore below its own directory on a relative path (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8429";>#8429</a>) <a href="https://github.com/devYRPauli";><code>@​devYRPauli</code></a></li> <li>Snowflake: ALTER USER policy attachment (AUTHENTICATION/PASSWORD/SESSION POLICY) and WORKLOAD_IDENTITY (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8367";>#8367</a>) <a href="https://github.com/cotsupa";><code>@​cotsupa</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>Snowflake: inherited grants (GRANT/REVOKE INHERITED), CREATE SEMANTIC VIEW and CREATE DATABASE ROLE privileges (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8366";>#8366</a>) <a href="https://github.com/cotsupa";><code>@​cotsupa</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>Trino: accept the DISTINCT qualifier on INTERSECT and EXCEPT (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8532";>#8532</a>) <a href="https://github.com/maksimtech";><code>@​maksimtech</code></a>, Claude Opus 5</li> <li>fix(cli): respect output_line_length in the rules listing (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8529";>#8529</a>) <a href="https://github.com/ddy314";><code>@​ddy314</code></a></li> <li>ClickHouse: accept the DISTINCT qualifier on INTERSECT and EXCEPT (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8533";>#8533</a>) <a href="https://github.com/maksimtech";><code>@​maksimtech</code></a>, Claude Opus 5</li> <li>Placeholder: ignore embedded colons in colon_optional_quotes (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8566";>#8566</a>) <a href="https://github.com/devYRPauli";><code>@​devYRPauli</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>ST04: keep the space before the outer END when flattening (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8568";>#8568</a>) <a href="https://github.com/devYRPauli";><code>@​devYRPauli</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>fix(snowflake): stop scripting IF terminators leaking into CASE expressions (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8468";>#8468</a>) <a href="https://github.com/michal-swiatowy";><code>@​michal-swiatowy</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>Oracle: parse the SQL*Plus SHOW command (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8484";>#8484</a>) <a href="https://github.com/itzzdev09";><code>@​itzzdev09</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>feat(clickhouse): add support for underscores in numeric literals and for hex and binary numeric literals (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8537";>#8537</a>) <a href="https://github.com/AndrewKurg";><code>@​AndrewKurg</code></a></li> <li>feat(clickhouse): add support for IS NOT DISTINCT FROM operator (<=>) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8528";>#8528</a>) <a href="https://github.com/AndrewKurg";><code>@​AndrewKurg</code></a></li> <li>Databricks: require SEQUENCE BY in a CREATE FLOW REPLACE USING spec (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8460";>#8460</a>) <a href="https://github.com/devYRPauli";><code>@​devYRPauli</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>fix: raise a clear error instead of crashing on a non-table <code>rules</code> value in pyproject.toml (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8493";>#8493</a>) <a href="https://github.com/udsy19";><code>@​udsy19</code></a></li> <li>fix(mysql): support multiple variables and expression defaults in DEC… (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8538";>#8538</a>) <a href="https://github.com/rfanth";><code>@​rfanth</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>fix(mysql): allow CALL without parentheses (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8539";>#8539</a>) <a href="https://github.com/rfanth";><code>@​rfanth</code></a>, <a href="https://github.com/claude";><code>@​claude</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.4.0] - 2026-10-02</h2> <h2>Highlights</h2> <p>This minor release introduces SQLMesh integration, new linting and formatting options, and a refreshed documentation site, alongside a broad set of dialect improvements and bug fixes.</p> <ul> <li><strong>SQLMesh projects can now use SQLFluff through the new <code>sqlfluff-templater-sqlmesh</code> plugin.</strong> The optional templater brings SQLFluff linting to SQLMesh models, with support for model definitions and macro rendering.</li> <li><strong>Two recent rules offer additional opt-in conventions.</strong> <code>CV13</code> encourages a pure <code>SELECT * FROM <cte></code> passthrough as the final query in a CTE-based model, following the dbt convention. <code>TQ04</code> prefers <code>expression AS alias</code> over T-SQL's <code>alias = expression</code> syntax. Both are currently disabled by default and can be enabled with <code>force_enable = True</code>.</li> <li><strong>The CLI gains GitLab Code Quality output</strong> through <code>--format gitlab</code>, allowing findings to appear directly in GitLab merge requests. This joins the existing SARIF and GitHub annotation formats for integrating SQLFluff into CI.</li> <li><strong>The Jinja templater now supports custom delimiters</strong>, including the <code><% ... %></code> syntax used by Snowflake CLI. <code>LT15</code> also gains an optional minimum number of blank lines between statements.</li> <li><strong><a href="https://docs.sqlfluff.com";>docs.sqlfluff.com</a> has migrated to a new documentation format.</strong> The site is more responsive, easier to search, and supports dark mode, with a design that fits the rest of the SQLFluff project.</li> </ul> <p>Beyond that, this release expands parsing support across Snowflake, MariaDB/MySQL, ClickHouse, PostgreSQL, Oracle, Databricks, Flink, Athena, SQLite, Trino, and other dialects. Rule and templater fixes improve reliability, reduce false positives, and prevent unsafe autofixes.</p> <p>This release also includes first-time contributions from <strong>forty-three</strong> new contributors. Thank you all for your contributions. 🏆</p> <h2>What’s Changed</h2> <ul> <li>Make stable the default docs landing version <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8631";>#8631</a> <a href="https://github.com/alanmcruickshank";><code>@​alanmcruickshank</code></a></li> <li>build(deps): bump github/issue-labeler from 3.4 to 3.5 in the github-actions group (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8618";>#8618</a>) <a href="https://github.com/apps/dependabot";><code>@​dependabot[bot]</code></a></li> <li>fix(AM02): preserve UNION's existing case instead of forcing a hardcoded one <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8534";>#8534</a> <a href="https://github.com/udsy19";><code>@​udsy19</code></a></li> <li>Redshift: parse array accessors in SUPER paths in the FROM clause <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8526";>#8526</a> <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>Prepare docs URL parity and production indexing <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8629";>#8629</a> <a href="https://github.com/alanmcruickshank";><code>@​alanmcruickshank</code></a></li> <li>ci: fix mypy type annotation for "subclass" <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8621";>#8621</a> <a href="https://github.com/keraion";><code>@​keraion</code></a></li> <li>docs: refine historical versions index <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8609";>#8609</a> <a href="https://github.com/alanmcruickshank";><code>@​alanmcruickshank</code></a></li> <li>Databricks: support Unity Catalog volume privileges in GRANT and REVOKE (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8512";>#8512</a>) <a href="https://github.com/taslater";><code>@​taslater</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>fix(mysql): parse DO statements (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8582";>#8582</a>) <a href="https://github.com/rfanth";><code>@​rfanth</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>Oracle: allow DELETE without the optional FROM keyword (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8576";>#8576</a>) <a href="https://github.com/MrDKOz";><code>@​MrDKOz</code></a>, <a href="https://github.com/apps/cubic-dev-ai";><code>@​cubic-dev-ai[bot]</code></a></li> <li>StarRocks: support PARTITION BY LIST (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8555";>#8555</a>) <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8595";>#8595</a> <a href="https://github.com/mishra-prince";><code>@​mishra-prince</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/0348222a3bcdb0226563f7349c5a39beb0641955";><code>0348222</code></a> Prep version 4.4.0 (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8632";>#8632</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/e474d10d83c755068c01228c553494e59282984d";><code>e474d10</code></a> Make stable the default docs landing version (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8631";>#8631</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/a1aa01d2fd756c87874ff562b4115a15d702188e";><code>a1aa01d</code></a> build(deps): bump github/issue-labeler from 3.4 to 3.5 in the github-actions ...</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/975eb0f1b2e0c182825c784c13d3cf3f053712b2";><code>975eb0f</code></a> fix(AM02): preserve UNION's existing case instead of forcing a hardcoded one ...</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/9bd815c29f0973c24aefdd01c45907b182456af6";><code>9bd815c</code></a> Redshift: parse array accessors in SUPER paths in the FROM clause (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8526";>#8526</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/ce5c974e8cc5f24c7a79d8f81ef36fc1ca735cf3";><code>ce5c974</code></a> Prepare docs URL parity and production indexing (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8629";>#8629</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/1ecba43e777657730d5ae2667638a87be21e3e76";><code>1ecba43</code></a> ci: fix mypy type annotation for "subclass" (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8621";>#8621</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/d528cd6a784b752d854db6638472a3cf9878ed43";><code>d528cd6</code></a> docs: refine historical versions index (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8609";>#8609</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/2e2275713d078f29529250f7ff883fbf66f83e0d";><code>2e22757</code></a> Databricks: support Unity Catalog volume privileges in GRANT and REVOKE (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8512";>#8512</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/16558d12b54a1f9af968ca838603dbde2bd9c630";><code>16558d1</code></a> fix(mysql): parse DO statements (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8582";>#8582</a>)</li> <li>Additional commits viewable in <a href="https://github.com/sqlfluff/sqlfluff/compare/4.3.0...4.4.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]
