Systems, methods, and apparatuses for implementing a BY ORGID command term within a multi-tenant aware structured query language

A method performed by system having at least a processor and a memory therein, wherein the method comprises:

• operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations;
• receiving a database query specifying a command term to filter all tables accessed pursuant to execution of the database query by an organization_id parameter corresponding to one of the plurality of distinct customer organizations;
• parsing the database query to identify the command term specified;
• parsing the database query to identify any part of the received database query corresponding to one or more tables within the multi-tenant database system;
• parsing the received database query to additionally identify a CONDITIONAL UNION command term specified by the received database query;
• wherein the CONDITIONAL UNION command term includes multiple SELECT statements forming a plurality of nested sub-queries within the received database query;
• and
• generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, wherein the new structured query language statement filters every reference to the one or more tables by the organization_id parameter;
• wherein generating the new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received comprises applying a BY ORG command term to all corresponding SELECT statements within the new structured query language statement to filter every table accessed by the organization_id parameter;
• and
• executing the new structured query language statement against the multi-tenant database system.

A system to execute within a host organization, wherein the system comprises:

• a processor and a memory to execute instructions at the system;
• a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations;
• a database bridge is configurable to receive a database query specifying a command term to filter all tables accessed pursuant to execution of the database query by an organization_id parameter corresponding to one of the plurality of distinct customer organizations, wherein the organization_id parameter is not passed with the database query received;
• wherein the database bridge is further configurable to determine the organization_id parameter by corresponding an originator of the database query to the organization_id parameter via a customer organization_id lookup function which identifies which one of the plurality of distinct customer organizations correspond to the originator based on account permissions associated with the originator or metadata associated with the originator or access rights associated with the originator;
• a parser to execute via the processor, wherein the parser is to parse the database query to identify the command term specified;
• the parser to further parse the database query to identify any part of the received database query corresponding to one or more tables within the multi-tenant database system;
• a translator to execute via the processor, wherein the translator is to generate a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, wherein the new structured query language statement filters every reference to the one or more tables by the organization_id parameter determined;
• and
• a database query interface to execute via the processor, wherein the database query interface is to execute the new structured query language statement against the multi-tenant database system.

Non-transitory computer readable storage media having instructions stored thereon that, when executed by a processor of a system, the instructions cause the system to perform operations including:

• operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations;
• receiving a database query specifying a command term to filter all tables accessed pursuant to execution of the database query by an organization_id parameter corresponding to one of the plurality of distinct customer organizations, wherein the organization_id parameter is not passed with the database query received;
• determining the organization_id parameter by corresponding an originator of the database query to the organization_id parameter via a customer organization_id lookup function which identifies which one of the plurality of distinct customer organizations correspond to the originator based on account permissions associated with the originator or metadata associated with the originator or access rights associated with the originator;
• parsing the database query to identify the command term specified;
• parsing the database query to identify any part of the received database query corresponding to one or more tables within the multi-tenant database system;
• generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, wherein the new structured query language statement filters every reference to the one or more tables by the organization_id parameter determined;
• and
• executing the new structured query language statement against the multi-tenant database system.