My knowledge of ElasticSearch is not good enough to tell whether
it can share a similar interface to SQL DBs, I would say it depends
of the interface. I would say "maybe yes" if we exclude the query
language from the specification.
There is a SQL interface for ES, but it is very limited: just SELECT-FROM-WHERE-GROUP BY-HAVING-ORDER BY-LIMIT, with only one table in FROM. There is no DML or DDL, and just a few metaqueries: DESCRIBE TABLE and SHOW TABLES|COLUMNS|FUNCTIONS.
Similarly, MongoDB works using the same principles as SQL when
you consider that it it takes a query as input and outputs a list of objects.
Unlike SQL objects are free-form.
There is no SQL interface to Mongo.