[hibernate-dev] Query generated for insert ... select

For an INSERT ... SELECT, Hibernate (in wip/6.0) will generate a SQL statement with parentheses around the select statement. This happens in AbstractSqlAstTranslator.visitQuerySpec(QuerySpec querySpec) because the querySpec is not a root. Firebird doesn't support a parenthesized select in insert (yet). What would be the best way to address this in the AstTranslator or elsewhere? Overriding the entire visitQuerySpec(QuerySpec querySpec) method could be brittle as significant changes would need to be replicated to the Firebird-specific translator, and this only really applies when processing a select in an insert statement (I think; there are some other places where Firebird doesn't support parenthesized selects where the standard does). Mark -- Mark Rotteveel