Now joinGet Supports Multi-Key Lookup

Why it matters

This feature improves the flexibility and efficiency of joins by enabling multi-key lookups with joinGet. It allows users to retrieve values from a joined table based on combinations of multiple key columns, solving the limitation of single-key lookups and enabling more complex and precise join conditions.

How to use it

Use the joinGet function by passing multiple keys as arguments to perform a multi-key lookup. The syntax extends the existing function to accept multiple key columns for matching. For example:

SELECT joinGet('table_name', 'value_column', key1, key2) FROM ...