I know this is an old item, but I've been struggling with this a lot, and would find something similar very very useful.
Often there are joining fields which are not foreign keys, and have different names. If previous join conditions were remembered and suggested next time, that would help a lot.
E.g.
select * from part p join inventory i on p.part_id = i.item_id
If we built the join condition by selecting each field from the dropdowns, is it possible to cache the entire join next time, so that when we join those two tables it includes part_id = item_id in the list of suggestions?
Geoff
supported this idea
·
I know this is an old item, but I've been struggling with this a lot, and would find something similar very very useful.
Often there are joining fields which are not foreign keys, and have different names. If previous join conditions were remembered and suggested next time, that would help a lot.
E.g.
select * from part p join inventory i on p.part_id = i.item_id
If we built the join condition by selecting each field from the dropdowns, is it possible to cache the entire join next time, so that when we join those two tables it includes part_id = item_id in the list of suggestions?