Allow variables with dot in sqlfluff:templater:python:context

[timchurch]

Search before asking

• I searched the issues and found no similar issues.

Description

SQLFluff python templater does not currently support variables that contain a dot - e.g. {foo.bar}

This SQL:

SELECT * FROM {foo.bar}

..with this config:

[sqlfluff:templater:python:context]
foo.bar = foobar

..raises this error:

sqlfluff.core.errors.SQLTemplaterError: Failure in Python templating: 'foo'. Have you configured your variables? https://docs.sqlfluff.com/en/stable/configuration.html#python-templater

Related tickets (but for Jinja templater):

• Allow variables with dot in jinja:context #4153
• sqlfluff:templater:jinja:context templater variables with period are not resolved #4019

Use case

Python format strings support variables that use dot notation for object attribute access. This is a valid Python example that is not yet supported by SQLFluff:

class MyObject:
    bar = "blah"


sql = "SELECT * FROM {foo.bar}"
context = {"foo": MyObject()}
print(sql.format(**context))

Dialect

This is not dialect specific.

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