Computerized system and method for optimizing queries in a templated virtual semantic layer

A non-transitory computer-readable storage medium tangibly encoded with computer-executable instructions, that when executed by a processor associated with a device, performs a method comprising:

• identifying, by the device, a database, the database comprising a plurality of information organized into at least a set of columns;
• identifying, by the device, a Column Object (CO) within a column of the database, the CO comprising information related to a column name, a Structured Query Language (SQL) expression and an alias;
• analyzing, by the device, the CO;
• creating, by the device, based on the analysis, a new CO related to the identified CO, the new CO comprising information related to the column name, a templated expression of the expression, and the alias;
• analyzing, by the device, information related to the new CO, and determining a type of dimension nesting, the type of dimension nesting being based on whether a referenced join is to occur as an inner query or outer query;
• and
• performing, by the device, the determined type of dimension nesting.

A device comprising:

• a processor configured to:
• identify a database, the database comprising a plurality of information organized into at least a set of columns;
• identify a Column Object (CO) within a column of the database, the CO comprising information related to a column name, a Structured Query Language (SQL) expression and an alias;
• analyze the CO;
• create, based on the analysis, a new CO related to the identified CO, the new CO comprising information related to the column name, a templated expression of the expression, and the alias;
• analyze information related to the new CO, and determine a type of dimension nesting, the type of dimension nesting being based on whether a referenced join is to occur as an inner query or outer query;
• and
• perform the determined type of dimension nesting.