oracle 12c implements SQL:2008, introduce at lease two useful feature.
1. fetch first n rows only / offset m rows fetch next n rows only
give up the crappy rownum
2. identity column
avoid sequence for auto increment clumn

please update DialectResolver also.