Add filter option on join query

[shanmuthu83]

Hi @toluaina

How to add the filter option in join query in schema.json file

for ex.. under children attribute

"relationship": {
          "variant": "object",
          "type": "one_to_many",
          "foreign_key": {
            "child": ["id"],
            "parent": ["id" ]
          }
        }

SELECT 
  * 
FROM 
  table_1 t1 
  LEFT JOIN table_2 t2 ON t1.id = t2.id 
  **AND t2.type = 'customer'**

[toluaina]

This is probably too difficult and likely to lead to complications.
I'd suggest using the plugin approach described here