There are two sql files in the resources:
kogito-runtimes/addons/common/persistence/jdbc/src/main/resources/sql/
create_tables.sql
exists_tables.sql
These sql files are written in postgresql syntax.
There is a specific addon for postgresql. The sql files in kogito-addons-persistence-jdbc should be written in standard sql.
There are two sql files in the resources: kogito-runtimes/addons/common/persistence/jdbc/src/main/resources/sql/
These sql files are written in postgresql syntax. There is a specific addon for postgresql. The sql files in kogito-addons-persistence-jdbc should be written in standard sql.