While my code runs as intended with this extension, the syntax for my CTAS tables is always marked as incorrect. I expect that even when using Azure Synapse Analytics syntax, the extension will not ...

Whenever I'm using a virtualenv with pylint, I'm calling it through python -m pylint. That way, I can avoid these kind of issues.