Multiple foreign tables in a single "or" statement

Currently with Supabase JS you can filter by nested joined tables by just just digging down, like this: .eq('table1.table2.table3', value) You can also filter an or statement by a foreign table like this: .or('column1.eq.value1, column2.eq.value2, { foreignTable: 'table2' }) But if there are multiple foreign tables we want to filter on in a single "or" statement, this is just not possible. This has led us to created a view for every single table we need to do searching on when the values we are searching are spread across multiple joined tables. So if I am getting something on table 1, but want to search by something from table 2 OR table 3, that just isn't possible right now, which feels like a huge oversight. My suggestion is to either allow the same drill-down syntax from how it can be used in other filter statements (like eq) or to allow us to provide an array of filter statements to an "or" statement where we can specif…