Excel API

SQL Frames already provides a very easy to learn API for data transformations using familiar SQL constructs. However, to make sure this technology is accessible to wider audience, an Excel compatible API is being provided.

This plugin is for people already familiar with Excel and not yet mastered SQL but want to try out SQL Frames. This plugin contains some of the most common Excel "Show Values As" functions provided by aggregate and pivot tables.

SQL Generation

Functions from this plugin are currently not compatible with auto-generation of SQL. Hence, if SQL generation is required, do not use this plugin.