Search before asking

• I searched the issues and found no similar issues.

What Happened

The duckdb dialect fails to parse the following star expressions

-- * RENAME
SELECT * RENAME (a AS b)
FROM tbl;

-- Pattern Matching
SELECT * LIKE 'col%'
FROM tbl;

SELECT * ILIKE 'col%'
FROM tbl;

SELECT * NOT LIKE 'col%'
FROM tbl;

SELECT * GLOB 'col*'
FROM tbl;

SELECT * SIMILAR TO 'col.'
FROM tbl;

Expected Behaviour

These should parse successfully.

Observed Behaviour

These return PRS errors.

How to reproduce

Use SQL queries above.
Use duckdb dialect.
Run sqlfluff parse.
PRS error occurs.

Dialect

duckdb

Version

sqlfluff 3.4.1

Configuration

[sqlfluff]
dialect = duckdb

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