SQL Lab Error 'str' object has no attribute 'set' about superset HOT 4 OPEN

Hey @deviardn! 👋 I'm here to help you with any bugs, questions, or contributions you have while waiting for a human maintainer. Let's squash those bugs together!

To resolve the "Microsoft SQL Server Error: 'str' object has no attribute 'set'" error in Apache Superset version 4.0.2 when using the SQL Lab menu, you should apply the fix from the pull request #27577 which addresses issues with SQL Server in the sqlglot library.

Here is the relevant fix:

# Ensure you have the latest version of sqlglot that includes the fix for SQL Server.
# You can update sqlglot by running:
pip install --upgrade sqlglot

This update should resolve the error by ensuring that the correct handling for SQL Server is applied ^[1].

To continue talking to Dosu, mention @dosu.

from superset.

Not sure if it's related or the same issue to the issue I'm facing:
#29853

from superset.

If these are the same, let's close one in favor of the other.

from superset.

@rusackas I've tested the suggestion with sqlglot, it's not the same issue.

from superset.