Join Tables in Live Connection

Join Tables in Live Connection

So my understanding is that it's not possible to join tables (or create lookup columns) for Live Connections with cloud databases (like Amazon Redshift). I know I can set up Data Import instead, but that's not ideal because I would quickly run into trouble with reaching the row count quota.

This is the one and only reason why I can't completely replace Tableau with Zoho Analytics and it's very unfortunate.

Is it possible that I'm missing something? Or if not, is this something that may be developed any time soon?