mysql - Compatibility issue between H2 DB queries and Sql Server -

i'm developing application uses h2 db . queries in h2 supported grammar not supported sql server , vice versa . there way make application work common query structure supports both h2 , sql server ? here queries .. 1st query

sql server syntax -

select columns  table_1 table_2  conditions 

h2 db equivalent

create table table_1  select columns table_2 conditions 

*the above h2 query wasnt supported sql server

2nd query

sql server syntax

update set columns table_1 join table_2 b on keys conditions  insert table_1(columns) select columns  table_2 conditions 

h2 db equivalent

1st part

 update table_1  set column=(select column table_2 b conditions)  

2nd part

 insert table_1(columns) select columns  table_2 conditions 

yes, rewrite queries.

the proper way create target table , say:

insert table2
select ... table1