what I want to do is to query Elasticsearch from kibana in a SQL'ish manner and in the same time create dynamically a suitable visualisation for the search returned by elasticsearch, can anyone please guide me through this process
There's no SQLish functionality at this stage.
I have found an elasticsearch plugin that can query the database as a relational one , I wonder if we can develop a kibana plugin that calls under the hood this elasticsearch plugin