dependabot[bot] opened a new pull request, #123: URL: https://github.com/apache/fineract-business-intelligence/pull/123
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.5.0] - 2026-10-30</h2> <h2>Highlights</h2> <p>This minor release focuses on performance, clearer diagnostics and new layout options, alongside a large wave of Databricks and SparkSQL support and a broad set of dialect improvements and bug fixes.</p> <ul> <li><strong>Linting is faster across the board.</strong> A series of performance changes removes quadratic work in the layout rules and <code>LT09</code>, reuses whole-file reflow sequences across rules, and skips parse subtrees that can't match. It also cuts fixed costs every linted file pays and sends less data to and from worker processes. The Rust engine also gets lower allocation overhead and a per-process regex cache.</li> <li><strong>Parse errors are easier to act on.</strong> Unparsable-section messages now name the unexpected token and show the grammar the parser expected. Diagnostics on templated code now carry full source positions.</li> <li><strong>New layout and convention options.</strong> <ul> <li><code>LT05</code> gains a <code>list_wrapping = fill</code> option that puts as many list elements on each line as fit, rather than one per line.</li> <li>The new <code>indented_using_on_newline</code> option indents <code>ON</code>/<code>USING</code> below a join target on its own line.</li> <li><code>CV03</code> adds a <code>require_multiline_forbid_single_line</code> trailing-comma policy.</li> <li><code>fixed_suffix</code> can now be set in config, not just on the CLI.</li> </ul> </li> <li><strong>Databricks and SparkSQL support grows a lot</strong>, including: <ul> <li>SQL scripting and stored procedures</li> <li>Unity Catalog <code>SHOW</code>/<code>DESCRIBE</code>, privileges and tags</li> <li><code>GEOGRAPHY</code>/<code>GEOMETRY</code> types</li> <li><code>EXECUTE IMMEDIATE</code> and named parameter markers</li> <li>SQL-bodied <code>CREATE FUNCTION</code></li> <li>a Databricks parameter style for the placeholder templater</li> </ul> </li> <li><strong>The Jinja templater supports more dbt behaviour.</strong> It adds dbt materialization blocks and the <code>fromjson</code>/<code>tojson</code> helpers, and fixes <code>return</code> handling in nested macros defined in the same file.</li> </ul> <p>Beyond that, this release expands parsing support across DuckDB, Snowflake, T-SQL, MySQL/MariaDB, PostgreSQL, ClickHouse, SQLite, Trino, Oracle, Redshift, BigQuery, Flink, Db2, StarRocks, Doris and other dialects. Rule fixes stop several autofixes from changing query meaning: <code>ST02</code>, <code>ST06</code>, <code>ST08</code>, <code>ST09</code> and <code>CV06</code> now preserve precedence, parentheses, operators and statement boundaries. Other fixes reduce false positives in <code>AL05</code>, <code>AM01</code>, <code>AM07</code>, <code>RF01</code>, <code>RF03</code> and <code>LT09</code>. SQLFluff also now supports Click 8.5.</p> <p>This release also includes first-time contributions from <strong>fifty-five</strong> new contributors. Thank you all for your contributions. 🏆</p> <h2>What’s Changed</h2> <ul> <li>Trino: parse CREATE/DROP MATERIALIZED VIEW (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8940";>#8940</a>) <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>Fix LT02 blank-line growth after empty inline templates (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8944";>#8944</a>) <a href="https://github.com/zhangxinyao88";><code>@​zhangxinyao88</code></a></li> <li>SparkSQL: Support multi-column TABLE() arguments (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8761";>#8761</a>) <a href="https://github.com/WittierDinosaur";><code>@​WittierDinosaur</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>T-SQL: Parse $PARTITION.<!-- raw HTML omitted -->() calls (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8917";>#8917</a>) <a href="https://github.com/pujitha24";><code>@​pujitha24</code></a></li> <li>Snowflake: Support aggregation and projection policies (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8936";>#8936</a>) <a href="https://github.com/sai-sakalam";><code>@​sai-sakalam</code></a></li> <li>Postgres: support GROUP BY DISTINCT / ALL (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8925";>#8925</a>) <a href="https://github.com/YashG1836";><code>@​YashG1836</code></a></li> <li>Fix pre-commit end-of-file-fixer failure on main (vertica fixture) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8929";>#8929</a>) <a href="https://github.com/YashG1836";><code>@​YashG1836</code></a></li> <li>Include source positions for templated diagnostics (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8697";>#8697</a>) <a href="https://github.com/dheeraj-juvvadi";><code>@​dheeraj-juvvadi</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>linter: surface the expected grammar in unparsable messages (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8558";>#8558</a>) <a href="https://github.com/taslater";><code>@​taslater</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>fix(RF03): only skip templated refs for the placeholder templater (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8561";>#8561</a>) <a href="https://github.com/udsy19";><code>@​udsy19</code></a></li> <li>Preserve expression precedence when ST02 negates a CASE (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8867";>#8867</a>) <a href="https://github.com/Jackmeson1";><code>@​Jackmeson1</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>ClickHouse: Support multiple comma-separated actions in ALTER TABLE (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8914";>#8914</a>) <a href="https://github.com/manjirisharma";><code>@​manjirisharma</code></a></li> <li>fix(vertica): support integer literals and DEFAULT in ALTER TABLE SET MERGEOUT (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8894";>#8894</a>) <a href="https://github.com/pranaysb";><code>@​pranaysb</code></a></li> <li>MySQL: support DESCRIBE, DESC and full EXPLAIN syntax (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8923";>#8923</a>) <a href="https://github.com/YashG1836";><code>@​YashG1836</code></a></li> <li>fix(doris): remove unsupported FlushStatementSegment from StatementSegment (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8901";>#8901</a>) <a href="https://github.com/Pyhroff";><code>@​Pyhroff</code></a></li> <li>fix(starrocks): remove unsupported FlushStatementSegment from StatementSegment (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8902";>#8902</a>) <a href="https://github.com/Pyhroff";><code>@​Pyhroff</code></a></li> <li>Fix pre-commit end-of-file-fixer failure on main (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8927";>#8927</a>) <a href="https://github.com/keraion";><code>@​keraion</code></a></li> <li>fix(doris): use CommaSegment for fixed range partition grammar (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8896";>#8896</a>) <a href="https://github.com/pranaysb";><code>@​pranaysb</code></a></li> <li>Test rule-filter options in the diff-quality integration (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8898";>#8898</a>) <a href="https://github.com/zhangxinyao88";><code>@​zhangxinyao88</code></a></li> <li>fix(LT09): do not rejoin single select target when line length exceeds limit (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8624";>#8624</a>) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8863";>#8863</a>) <a href="https://github.com/askarshabdanov1-collab";><code>@​askarshabdanov1-collab</code></a></li> <li>SQLite: allow MATCH, VIRTUAL and LAST as identifiers (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8905";>#8905</a>) <a href="https://github.com/kennywu411-dev";><code>@​kennywu411-dev</code></a></li> <li>perf: skip subtrees that cannot match and trim redundant rule work (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8910";>#8910</a>) <a href="https://github.com/joshmarkovic";><code>@​joshmarkovic</code></a></li> <li>fix(postgres): resolve COLUMN keyword ref in AlterForeignTableActionSegment (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8888";>#8888</a>) <a href="https://github.com/pranaysb";><code>@​pranaysb</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.5.0] - 2026-10-30</h2> <h2>Highlights</h2> <p>This minor release focuses on performance, clearer diagnostics and new layout options, alongside a large wave of Databricks and SparkSQL support and a broad set of dialect improvements and bug fixes.</p> <ul> <li><strong>Linting is faster across the board.</strong> A series of performance changes removes quadratic work in the layout rules and <code>LT09</code>, reuses whole-file reflow sequences across rules, and skips parse subtrees that can't match. It also cuts fixed costs every linted file pays and sends less data to and from worker processes. The Rust engine also gets lower allocation overhead and a per-process regex cache.</li> <li><strong>Parse errors are easier to act on.</strong> Unparsable-section messages now name the unexpected token and show the grammar the parser expected. Diagnostics on templated code now carry full source positions.</li> <li><strong>New layout and convention options.</strong> <ul> <li><code>LT05</code> gains a <code>list_wrapping = fill</code> option that puts as many list elements on each line as fit, rather than one per line.</li> <li>The new <code>indented_using_on_newline</code> option indents <code>ON</code>/<code>USING</code> below a join target on its own line.</li> <li><code>CV03</code> adds a <code>require_multiline_forbid_single_line</code> trailing-comma policy.</li> <li><code>fixed_suffix</code> can now be set in config, not just on the CLI.</li> </ul> </li> <li><strong>Databricks and SparkSQL support grows a lot</strong>, including: <ul> <li>SQL scripting and stored procedures</li> <li>Unity Catalog <code>SHOW</code>/<code>DESCRIBE</code>, privileges and tags</li> <li><code>GEOGRAPHY</code>/<code>GEOMETRY</code> types</li> <li><code>EXECUTE IMMEDIATE</code> and named parameter markers</li> <li>SQL-bodied <code>CREATE FUNCTION</code></li> <li>a Databricks parameter style for the placeholder templater</li> </ul> </li> <li><strong>The Jinja templater supports more dbt behaviour.</strong> It adds dbt materialization blocks and the <code>fromjson</code>/<code>tojson</code> helpers, and fixes <code>return</code> handling in nested macros defined in the same file.</li> </ul> <p>Beyond that, this release expands parsing support across DuckDB, Snowflake, T-SQL, MySQL/MariaDB, PostgreSQL, ClickHouse, SQLite, Trino, Oracle, Redshift, BigQuery, Flink, Db2, StarRocks, Doris and other dialects. Rule fixes stop several autofixes from changing query meaning: <code>ST02</code>, <code>ST06</code>, <code>ST08</code>, <code>ST09</code> and <code>CV06</code> now preserve precedence, parentheses, operators and statement boundaries. Other fixes reduce false positives in <code>AL05</code>, <code>AM01</code>, <code>AM07</code>, <code>RF01</code>, <code>RF03</code> and <code>LT09</code>. SQLFluff also now supports Click 8.5.</p> <p>This release also includes first-time contributions from <strong>fifty-five</strong> new contributors. Thank you all for your contributions. 🏆</p> <h2>What’s Changed</h2> <ul> <li>Trino: parse CREATE/DROP MATERIALIZED VIEW <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8940";>#8940</a> <a href="https://github.com/adhavan18";><code>@​adhavan18</code></a></li> <li>Fix LT02 blank-line growth after empty inline templates <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8944";>#8944</a> <a href="https://github.com/zhangxinyao88";><code>@​zhangxinyao88</code></a></li> <li>SparkSQL: Support multi-column TABLE() arguments (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8761";>#8761</a>) <a href="https://github.com/WittierDinosaur";><code>@​WittierDinosaur</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>T-SQL: Parse $PARTITION.<!-- raw HTML omitted -->() calls <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8917";>#8917</a> <a href="https://github.com/pujitha24";><code>@​pujitha24</code></a></li> <li>Snowflake: Support aggregation and projection policies <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8936";>#8936</a> <a href="https://github.com/sai-sakalam";><code>@​sai-sakalam</code></a></li> <li>Postgres: support GROUP BY DISTINCT / ALL <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8925";>#8925</a> <a href="https://github.com/YashG1836";><code>@​YashG1836</code></a></li> <li>Fix pre-commit end-of-file-fixer failure on main (vertica fixture) <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8929";>#8929</a> <a href="https://github.com/YashG1836";><code>@​YashG1836</code></a></li> <li>Include source positions for templated diagnostics (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8697";>#8697</a>) <a href="https://github.com/dheeraj-juvvadi";><code>@​dheeraj-juvvadi</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>linter: surface the expected grammar in unparsable messages (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8558";>#8558</a>) <a href="https://github.com/taslater";><code>@​taslater</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>fix(RF03): only skip templated refs for the placeholder templater <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8561";>#8561</a> <a href="https://github.com/udsy19";><code>@​udsy19</code></a></li> <li>Preserve expression precedence when ST02 negates a CASE (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8867";>#8867</a>) <a href="https://github.com/Jackmeson1";><code>@​Jackmeson1</code></a>, <a href="https://github.com/claude";><code>@​claude</code></a></li> <li>ClickHouse: Support multiple comma-separated actions in ALTER TABLE <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8914";>#8914</a> <a href="https://github.com/manjirisharma";><code>@​manjirisharma</code></a></li> <li>fix(vertica): support integer literals and DEFAULT in ALTER TABLE SET MERGEOUT <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8894";>#8894</a> <a href="https://github.com/pranaysb";><code>@​pranaysb</code></a></li> <li>MySQL: support DESCRIBE, DESC and full EXPLAIN syntax <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8923";>#8923</a> <a href="https://github.com/YashG1836";><code>@​YashG1836</code></a></li> <li>fix(doris): remove unsupported FlushStatementSegment from StatementSegment <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8901";>#8901</a> <a href="https://github.com/Pyhroff";><code>@​Pyhroff</code></a></li> <li>fix(starrocks): remove unsupported FlushStatementSegment from StatementSegment <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8902";>#8902</a> <a href="https://github.com/Pyhroff";><code>@​Pyhroff</code></a></li> <li>Fix pre-commit end-of-file-fixer failure on main <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8927";>#8927</a> <a href="https://github.com/keraion";><code>@​keraion</code></a></li> <li>fix(doris): use CommaSegment for fixed range partition grammar <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8896";>#8896</a> <a href="https://github.com/pranaysb";><code>@​pranaysb</code></a></li> <li>Test rule-filter options in the diff-quality integration <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8898";>#8898</a> <a href="https://github.com/zhangxinyao88";><code>@​zhangxinyao88</code></a></li> <li>fix(LT09): do not rejoin single select target when line length exceeds limit (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8624";>#8624</a>) <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8863";>#8863</a> <a href="https://github.com/askarshabdanov1-collab";><code>@​askarshabdanov1-collab</code></a></li> <li>SQLite: allow MATCH, VIRTUAL and LAST as identifiers <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8905";>#8905</a> <a href="https://github.com/kennywu411-dev";><code>@​kennywu411-dev</code></a></li> <li>perf: skip subtrees that cannot match and trim redundant rule work <a href="https://redirect.github.com/sqlfluff/sqlfluff/pull/8910";>#8910</a> <a href="https://github.com/joshmarkovic";><code>@​joshmarkovic</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/0a7c698408dc56e5efcbe37edc1ec23c782c003b";><code>0a7c698</code></a> Prep version 4.5.0 (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8945";>#8945</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/9ccda819bdfc68d671a7ab871d6adf518a18302f";><code>9ccda81</code></a> Trino: parse CREATE/DROP MATERIALIZED VIEW (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8940";>#8940</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/4d500c1369be381e6399ccb715c07d55ee655d4c";><code>4d500c1</code></a> Fix LT02 blank-line growth after empty inline templates (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8944";>#8944</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/97551769341f0425a31b72703ad7ce3267b3dd4b";><code>9755176</code></a> T-SQL: Parse $PARTITION.<function>() calls (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8917";>#8917</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/8461825206e90da370b52f424364db6e6c7c8cd1";><code>8461825</code></a> SparkSQL: Support multi-column TABLE() arguments (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8761";>#8761</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/d471b5c2a5cdcc8be7da83d6033c036a6060782d";><code>d471b5c</code></a> Snowflake: Support aggregation and projection policies (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8936";>#8936</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/3cc6cc2fb092b812034a8f2bd1cc9af3c18bcfa4";><code>3cc6cc2</code></a> Postgres: support GROUP BY DISTINCT / ALL (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8925";>#8925</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/85e6a3e0f094644058a4e052da4d1751e8c7e045";><code>85e6a3e</code></a> Fix pre-commit end-of-file-fixer failure on main (vertica fixture) (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8929";>#8929</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/f117441fe7f3acc2a59f5008619ad95b216835fd";><code>f117441</code></a> linter: surface the expected grammar in unparsable messages (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8558";>#8558</a>)</li> <li><a href="https://github.com/sqlfluff/sqlfluff/commit/60c100bf89a69ff5097311aaef3f3e7e59238ad6";><code>60c100b</code></a> Include source positions for templated diagnostics (<a href="https://redirect.github.com/sqlfluff/sqlfluff/issues/8697";>#8697</a>)</li> <li>Additional commits viewable in <a href="https://github.com/sqlfluff/sqlfluff/compare/4.4.0...4.5.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]
