Systems and methods for storing and accessing database queries

A method for resolving user inputs to queries to an underlying data platform, comprising:

• receiving, via a user interface from a user device associated with a user, natural language user input related to querying a structured database system, the natural language user input including non-structured search terms;
• identifying, in a database storing a plurality of structured data queries and based on metadata identifiers relating the natural language user input with the structured data query, a structured data query associated with the natural language user input;
• determining, based on the natural language user input, a set of selective parameters associated with the identified structured data query, wherein the set of selective parameters includes at least one parameter comprising at least one of a table name, a column name, a logical operator, or a column value of the structured data query;
• obtaining a set of permissions associated with the user;
• in response to determining that the set of permissions associated with the user is a first set of permissions, modifying the set of selective parameters based on the first set of permissions and generating for display, via the user interface, an input field comprising text of the structured data query with the modified set of selective parameters, wherein the user is enabled to modify the text of the structured data query;
• in response to determining that the set of permissions associated with the user is a second set of permissions that is more restrictive than the first set of permissions, modifying the set of selective parameters based on the second set of permissions and generating for display, via the user interface, a corresponding input field for each selective parameter of the set of selective parameters, wherein each input field enables the user to select and deselect one or more selective parameter of the set of selective parameters;
• receiving, via the user interface, configuration information for configuring the one or more selective parameters;
• configuring an executable data query by configuring the one or more selective parameters for the identified structured data query based on the received configuration information;
• executing the executable data query based on the configured one or more selective parameters;
• and
• providing, via the user interface, data returned from the structured database system responsive to the execution of the executable data query.

A non-transitory computer-readable media comprising instructions that, when executed by one or more processors, cause operations comprising:

• receiving, via a user interface from a user device associated with a user, natural language user input related to querying a structured database system, the natural language user input including non-structured search terms;
• identifying, in a database storing a plurality of structured data queries and based on metadata identifiers relating the natural language user input with the structured data query, a structured data query associated with the natural language user input;
• determining, based on the natural language user input, a set of selective parameters associated with the identified structured data query, wherein the set of selective parameters includes at least one parameter comprising at least one of a table name, a column name, a logical operator, or a column value of the structured data query;
• obtaining a set of permissions associated with the user;
• in response to determining that the set of permissions associated with the user is a first set of permissions, modifying the set of selective parameters based on the first set of permissions and generating for display, via the user interface, an input field comprising text of the structured data query with the modified set of selective parameters, wherein the user is enabled to modify the text of the structured data query;
• in response to determining that the set of permissions associated with the user is a second set of permissions more restrictive than the first set of permissions, modifying the set of selective parameters based on the second set of permissions and generating for display, via the user interface, a corresponding input field for each selective parameter of the set of selective parameters, wherein each input field enables the user to select and deselect one or more selective parameter of the set of selective parameters;
• receiving, via the user interface, configuration information for configuring the one or more selective parameters;
• configuring an executable data query by configuring the one or more selective parameters for the identified structured data query based on the received configuration information;
• executing the executable data query based on the configured one or more selective parameters;
• and
• providing, via the user interface, data returned from the structured database system responsive to the execution of the executable data query.