I'll admit I'm not super familiar with using nested/embedded syntax files for vim, but I know that it does support different highlighting for different sections. It would be fantastic to be able to have e.g. Postgres syntax highlighting inside an sql statement.