Systems and methods for data retrieval from a database indexed by an external search engine

A computer processing system comprising:

• a processing unit;
• a communications interface;
• and
• a non-transitory computer-readable storage medium storing sequences of instructions, which when executed by the processing unit, cause the processing unit to:
• receive, from a client device, a request defining a structured query language (SQL) query;
• process the SQL query to identify a set of search engine clauses and a set of non-search engine clauses within the SQL query;
• convert the set of search engine clauses into a search engine query;
• communicate the search engine query to a search engine for execution;
• receive, from the search engine, search results based on the search engine query, the results including object identifiers for one or more objects that match the search engine query;
• replace the set of the search engine clauses with a set of new elements generated based on the object identifiers contained in the search results;
• generate a modified SQL query using the set of new elements and the set of non-search engine clauses;
• execute the modified SQL query with respect to a database;
• and
• receive and returning results of the executed modified SQL query to the client device.

A non-transitory computer-readable storage medium storing instructions, which when executed by a processing unit, cause the processing unit to:

• receive, from a client device, a request defining a structured query language (SQL) query;
• process the SQL query to identify a set of search engine clauses and a set of non-search engine clauses within the SQL query;
• convert the set of search engine clauses into a search engine query;
• communicate the search engine query to a search engine for execution;
• receive, from the search engine, search results based on the search engine query, the results including object identifiers for one or more objects that match the search engine query;
• replace the set of the search engine clauses with a set of new elements generated based on the object identifiers contained in the search results;
• generate a modified SQL query using the set of new elements and the set of non-search engine clauses;
• execute the modified SQL query with respect to a database;
• and
• receive and returning results of the executed modified SQL query to the client device.