Cosmopolitan Driver RDBMS Storage Plugin in Java - Query JOSON
Apache Drill looks very interesting and powerful.
Means no more linked servers and the queries scale well! Just think you could combine data from Elastic Search, SQL Server, CSV files, JSON REST services, Cassandra or MySQL all in one query!
A quite a nice video can be found here. I jumped to the most interesting bit.
Query and performance:
Watching some videos about it: