SQL connector syntax validation

(Migrated from https://github.com/syndesisio/syndesis/issues/5400)

Author: Gary Gaughan
Assignees: unassigned

This is a...

[pre][code]
[ x] Feature request
[ ] Regression (a behavior that used to work and stopped working in a new release)
[ ] Bug report [!-- Please search GitHub for a similar issue or PR before submitting --]
[ ] Documentation issue or request
[/code][/pre]

Description

Limitations in the SQL connector are not giving enough detail on what subset of SQL is valid.
SQL connector does not provide immediate SQL statement validation. (I don't mean the table schema, but simple SQL grammar validations)
We may need to expand our syntax for DV.