This limitation is not from RxDBGRid, if you try to filter with LookupFields with Zeos components will get the same result.
I did some changes to rxdbgrid unit to avoid this problem and it worked for my project. I hope this modifications work for you.
There is one disadvantage, keys are not sorted, but for my project this was not a limitation.