- Patent Title: Precompiled SQL queries that allow for dynamic selection of columns
-
Application No.: US16852395Application Date: 2020-04-17
-
Publication No.: US11341130B2Publication Date: 2022-05-24
- Inventor: Rohitashva Mathur
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Wong & Rees LLP
- Agent Zhichong Gu
- Main IPC: G06F16/2452
- IPC: G06F16/2452 ; G06F16/2455 ; G06F16/22 ; G06F16/242

Abstract:
A query to retrieve database values for a first subset of table columns in a database table is determined. Runtime column selection variables are set up to identify the first subset of table columns for data retrieval, and are dynamically bound to a prepared query statement with single-column query statements joined by interstitial union operators. Each single-column query statement in the prepared query statement specifies a single-column query directed to a corresponding table column with a corresponding predicate to be bound at runtime dynamically with a corresponding portion of the one or more runtime column selection variables. The predicate is evaluated to be true or false in dependence on whether the corresponding table column is in the first subset of table columns. The prepared query statement is executed to retrieve database values for the first subset of table columns in the database table.
Public/Granted literature
- US20200242117A1 PRECOMPILED SQL QUERIES THAT ALLOW FOR DYNAMIC SELECTION OF COLUMNS Public/Granted day:2020-07-30
Information query