Internet of things structured query language query formation

A method comprising:

• obtaining a freeform search query having one or more search terms;
• identifying one or more tokens in the freeform search query, each token corresponding to a search term or combination of neighboring search terms in the freeform search query;
• obtaining, from a database, a graph structure and flat data corresponding to the graph structure, the graph structure containing a plurality of nodes, each node corresponding to a data type of the flat data and corresponding to one or more pieces of data in the flat data of the corresponding data type, the graph structure further containing a plurality of edges connecting one or more of the plurality of nodes, each edge corresponding to a link between an attribute of a node at one side of the edge and an attribute of a node at another side of the edge;
• performing a search for results relevant to the identified one or more tokens using a first search process, the first search process using the graph structure and flat data corresponding to the graph structure to rank search results according to a first ranking order, the search additionally populating a why found table indicating one or more reasons why each search result was found;
• joining pieces of data corresponding to the results relevant to the identified one or more tokens using the why found table, forming a view;
• identifying one or more operators in the freeform search query;
• locating one or more patterns of operators and terms, in a pattern database, matching the one or more operators and one or more surrounding terms in the freeform search query;
• and
• based on the located one or more patterns and the view, creating a structured query language (SQL) command corresponding to the freeform search query.

A non-transitory machine-readable storage medium comprising instructions that, when implemented by one or more machines, cause the one or more machines to perform operations comprising:

• obtaining a freeform search query having one or more search terms;
• identifying one or more tokens in the freeform search query, each token corresponding to a search term or combination of neighboring search terms in the freeform search query;
• obtaining, from a database, a graph structure and flat data corresponding to the graph structure, the graph structure containing a plurality of nodes, each node corresponding to a data type of the flat data and corresponding to one or more pieces of data in the flat data of the corresponding data type, the graph structure further containing a plurality of edges connecting one or more of the plurality of nodes, each edge corresponding to a link between an attribute of a node at one side of the edge and an attribute of a node at another side of the edge;
• performing a search for results relevant to the identified one or more tokens using a first search process, the first search process using the graph structure and Hat data corresponding to the graph structure to rank search results according to a first ranking order, the search additionally populating a why found table indicating one or more reasons why each search result was found;
• joining pieces of data corresponding to the results relevant to the identified one or more tokens using the why found table, forming a view;
• identifying one or more operators in the freeform search query;
• locating one or more patterns of operators and terms, in a pattern database, matching the one or more operators and one or more surrounding terms in the freeform search query;
• and
• based on the located one or more patterns and the view, creating a structured query language (SQL) command corresponding to the freeform search query.