yeah, it's definitely a challenge, you could also just overfetch a bit if it is relatively likely that the checks will pass, if it's highly unlikely then a lookup based solution would be better