code completion of correlated subqueries and where exists ( .. )
Hi
Love DbForge but I find I'm always writing this sort of query
UPDATE
client
SET
client.foo = 0
WHERE EXISTS
(
SELECT
1
FROM
clientRegion
WHERE
clientRegion.clientId = client.id AND ....
)
it would be ideal if dbforge could recommend some completions for the correlated portion inside the ( ) based on fk's in the same way it does for joins.
1
vote
![](https://secure.gravatar.com/avatar/e100a0e15608afa604aac982a4e76537?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)