Make SQL dialects extensible with the ability to load dynamically

[yruslan]

Background

Currently, Pramen supports a fixed set of JDBC drivers for its JDBC connector. It could be beneficial to make this set of drivers to be extensible by users as plugins.

This can be easily achieved if Pramen opens SqlGenerator trait and allows custom mappings of drivers to SQL generator classes.

Feature

Make SQL dialects extensible with the ability to load dynamically.

Example

pramen.sql.generators = [
  { driver="org.postgresql.Driver", class = "za.co.absa.pramen.core.sql.SqlGeneratorPostgreSQL" },
  { driver="com.simba.hive.jdbc41.HS2Driver", class = "za.co.absa.pramen.core.sql.SqlGeneratorHive" }
]