Elasticsearch cross index Join plugin (siren.solutions)

Is there a plugin to let me use SQL to query Elasticsearch?

Yes there is but its a different thing. This will do Joins across Indexes, that plugin will just give you a SQL syntax but will do only some form of joins - not in the range of millions.