Details
Description
The current SQL parser developped with DBase III JDBC driver has many limitations, and it can only works for simple SELECT statements.
The Calcite open source project might be of great help if it matches our need.
This task is a PoC that if it goes well, will allow the removal of
org.apache.sis.internal.shapefile.jdbc.sql.CrudeSQLParser
org.apache.sis.internal.shapefile.jdbc.sql.ConditionalClauseResolver
org.apache.sis.internal.shapefile.jdbc.sql.ClauseResolver
in favor of the Calcite API