6. Object Mapping

General usage: 5.7 Object Mapping. Status links explain differences for each data source.

Data source	Table Mapping	Camel Case	Name Sensitivity	Result Column Case	Write Policy	JSON Field Mapping	Statement Templates	Key strategies
MySQL	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	◐ Partial
PostgreSQL	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
Oracle	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
SQL Server	✓ Supported	✓ Supported	◐ Partial	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
DB2	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
H2	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported
ClickHouse	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	◐ Partial
Redis	✕ Unsupported	✕ Unsupported	✕ Unsupported	✕ Unsupported	✕ Unsupported	✕ Unsupported	✕ Unsupported	✕ Unsupported
MongoDB	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✓ Supported	✕ Unsupported	◐ Partial
ES 6	✓ Supported	✓ Supported	◐ Partial	✓ Supported	✓ Supported	✓ Supported	✕ Unsupported	◐ Partial
ES 7	✓ Supported	✓ Supported	◐ Partial	✓ Supported	✓ Supported	✓ Supported	✕ Unsupported	◐ Partial
Milvus	✓ Supported	✓ Supported	◐ Partial	✓ Supported	✓ Supported	✓ Supported	✕ Unsupported	◐ Partial

• Table Mapping: default and explicit mappings, including ignored properties.
• Name Sensitivity: database rules for table/column name casing and useDelimited quoting.
• Result Column Case: use caseInsensitive to control how returned column names match properties.
• Write Policy: INSERT/UPDATE participation, NULL handling, and selected fields.
• JSON Field Mapping: map entity properties to one field; direct JSON value conversion is covered under Type Handlers.
• Key strategies: assigned, auto-increment, UUID, sequence, and custom generation; status links explain each datasource’s strategy boundaries.

Empty-string and array round trips are listed under Type Handlers.