Enhancement: enable --show-lint-violations for sqlfluff fix

[yaozhang09]

Currently: unfixable violations when running sqlfluff fix causes failed check with the error [n unfixable linting violations found]

Enhancement: be able to see what rules failed in the output with the sqlfluff flag --show-lint-violations so that the dev can go into the code and manually fix. In general have an option to pass additional options/flags to the action when running fix or lint

here is sqlfluff feature:
sqlfluff/sqlfluff#3788

[yu-iskw]

That sounds good. But I think supporting the feature requires a lot of efforts, because --show-lint-violatinos doesn't output as JSON or any other format to easily parse. Parsing the current format would be a bit hassle. If sqlfluff enables us to show lint violations as JSON in the future, I will consider we support the feature.

sqlfluff/sqlfluff#3788 (comment)