hey all! I see that sql support is in alpha and I'd like to get a sense of what sort of things are missing from a full-fledged support. i want to use pants to handle sql files in my monorepo, and for that i think I really only need pants to be able to lint/format sql files and have those sql files be available as targets for my python functions that parse and execute them. is the current level of support not developed enough for me to be able to do this using pants in a production app?

The primary thing the sql support can do today is run: sqlfluff https://www.pantsbuild.org/stable/reference/subsystems/sqlfluff So if that is the linter you want it might be good enough for you

I’m also wondering what you’d want out of a SQL-specific integration aside from linting/formatting; right now you could model your SQL files as

file

or

resource

targets and achieve most of what you want without SQL-specific behavior.