> Does Teiid support unicode characters in the names of tables, views, constraints and fields ?
> Do the names have to be quoted in these cases ?
No, that is optional.
> What validations checks are their for legal names ?
Unquoted names must begin with @ # or a letter and only contain letters, digits, or _. Letters may be any upper or lower case ascii letter or any unicode character in the range 0153-fffd. See the regex pattern for letter on BNF for SQL Grammar | Teiid Documentation
> Any commonly known gotcha's ?
Depending upon the client you can use the utf character directly or Teiid supports the escape syntax \uXXXX
If you find any issues just let us know.
Thanks Steven, if we find anything we'll let you know.