Added JOIN Support for Table Functions

Why it matters

This feature enables users to use table functions directly in JOIN clauses, allowing more flexible and dynamic data retrieval by joining query results with generated or external data represented by table functions. It expands the querying capabilities and simplifies workflows where intermediate datasets are generated on-the-fly.

How to use it

Use table functions in the JOIN clause as you would use regular tables. For example:

SELECT *
FROM main_table
JOIN someTableFunction(params) AS tf
ON main_table.id = tf.id