Warning when parsing filepath in pandas.SQLQueryDataset even though pipeline works fine.

[galenseilis]

Description

https://kedro-org.slack.com/archives/C03RKP2LW64/p1709912797979079

Context

How has this bug affected you? What were you trying to accomplish?

The impact is relatively minor. I just see a warning.

Steps to Reproduce

1. Put a SQL script into an accessible path.
2. Put a SQL query dataset in the catalog with a filepath assigned to the path of the SQL script.
3. Run kedro.

Expected Result

I expect that a warning should not be raised if nothing is wrong or situationally risky.

Actual Result

I get a warning even though the pipeline works as desired. Purportedly this might be a Kedro-viz issue.

See here.

Your Environment

Include as many relevant details as possible about the environment you experienced the bug in:

• Web browser system and version: N/A
• Operating system and version: Windows 10
• NodeJS version used (if relevant): N/A
• Kedro version used (if relevant): See here.
• Python version used (if relevant): 3.10