IBM i does not support ColumnOperators.match()

[naveen-ram]

This uses the MATCH keyword in the sql query condition clause with is not a supported keyword in IBM i Db2. Should look for a work around here.

[naveen-ram]

ColumnOperators.match() is used for text search, IBM i doesn't support the MATCH sql keyword but it does support the CONTAINS which Oracle backend also uses. It however require that OmniFind Text Search Server for DB2® for i be installed and started to use this key word. @kadler should I proceed with this, find a different work around, or add this to documentation as a known issue.

Here is the documentation of the match function:
https://docs.sqlalchemy.org/en/13/core/sqlelement.html#sqlalchemy.sql.operators.ColumnOperators.match

Here is the documentation on the CONTAINS keyword.
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_74/db2/rbafzscacontains.htm