union-subclass + SetLockMode does not work on all dialects
Description
System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
This does not work for any dialect