Search before asking

• I searched the issues and found no similar issues.

What Happened

File extension with multiple parts (eg .sql.j2) are not discovered by sqlfluff anymore when running the command line

Expected Behaviour

sqlfluff discevering these file and running lint on them

Observed Behaviour

nothing happen

How to reproduce

touch query.sql
touch query.sql.j2

sqlfluff lint --dialect=ansi .

=> query.sql.j2 isn't discovered

Dialect

any

Version

sqlfluff, version 3.2.0

From the test I ran, it occur since 3.1.1

Configuration

None

Are you willing to work on and submit a PR to address the issue?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct