Enabling Semantic Queries In SQL Using Word Embedding

In today’s world, there is an increase in the demand for Machine Learning. This leads to tremendous efforts to reduce the skills/efforts needed for these tasks. One of the most promising strategies out there is to incorporate these capabilities to standard SQL, It started with Oded Shmueli paper and got implemented for elastic-search and PostgreSQL.

In order to enable those capabilities in SQL, we need to insert actual semantic meaning to database entities (rows/columns/tables). We do so by incorporate word embedding vectors into our database. so we could ask queries such as “show me all the rows similar to this row.” which is something you can’t do with standard SQL.

All we need to get magic in our database is to incorporate word embedding in the right way.