REMAP_STRUCT

DuckDB

remap_struct(input, target_type, mapping, defaults)

• input: ANY
• target_type: ANY
• mapping: ANY
• defaults: ANY

Example

SELECT remap_struct({'i': 1, 'j': 2}, NULL::ROW(v1 INT, v2 INT, v3 INT), {'v1': 'j', 'v3': 'i'}, {'v2': NULL::INTEGER});