Systems, methods, and apparatuses for implementing conditional statement execution within a multi-tenant aware structured query language

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 to receive a database query specifying a command term to conditionally execute a sub-portion of the database query when a Boolean evaluation specified with the database query resolves to true and to negate execution of the sub-portion of the database query when the Boolean evaluation resolves to false;
• a parser to execute via the processor, wherein the parser is to parse the database query to identify the Boolean evaluation when the command term to conditionally execute the sub-portion of the database query is identified within the received database query;
• the parser to further 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 the sub-portion of the database query to be conditionally executed or negated pursuant to the Boolean evaluation;
• a translator to execute via the processor, wherein the translator is to resolve the Boolean expression to either true or false prior to generating a new structured query language statement to be executed against the multi-tenant database system;
• wherein the translator is to further generate the new structured query language statement to be executed against the multi-tenant database system in fulfillment of the database query received, wherein the new structured query language statement includes a semantic structure to execute the sub-portion of the database query when the Boolean evaluation has been resolved to true and omits from execution the sub-portion of the database query when the Boolean evaluation has been resolved to false;
• 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 conditionally execute a sub-portion of the database query when a Boolean evaluation specified with the database query resolves to true and to negate execution of the sub-portion of the database query when the Boolean evaluation resolves to false;
• parsing the database query to identify the Boolean evaluation when the command term to conditionally execute the sub-portion of the database query is identified within the received database query;
• 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 the sub-portion of the database query to be conditionally executed or negated pursuant to the Boolean evaluation;
• resolving the Boolean expression to either true or false prior to generating a new structured query language statement to be executed against the multi-tenant database system;
• generating the new structured query language statement to be executed against the multi-tenant database system in fulfillment of the database query received, wherein the new structured query language statement includes a semantic structure to execute the sub-portion of the database query when the Boolean evaluation has been resolved to true and omits from execution the sub-portion of the database query when the Boolean evaluation has been resolved to false;
• and
• executing the new structured query language statement against the multi-tenant database system.