sfirke commented on issue #31913: URL: https://github.com/apache/superset/issues/31913#issuecomment-3339601151
I can confirm this continues to be the case in Superset 6.0.0rc2, albeit maybe with a different error message. I ran this in SQL Lab and saved it as a virtual dataset: ``` DECLARE @min_kWh INT = 1000 SELECT day, kWh, SiteName FROM dbo.vw_Municipal_Solar_Production WHERE kWh > @min_kWh ``` Then when I tried to make a chart with that dataset I got this error: > Unable to parse SQL > Error parsing near 'DECLARE' at line 2:13 > > FROM (DECLARE @min_kWh INT = 1000 I don't think this is a bug to actively work on, it's enough to say "Superset doesn't support DECLARE/SET." I think we can close this, the content will still be there for others who may even continue the discussion, but it will clean up our bug tracking. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
