Abstract: A facility for querying user-defined database columns is described. The facility receives a database query referring to one or more database columns, at least one of the referred-to database columns being a user-defined database column. The facility provides access to a database query result generated for the perceived database query via a programmatic object.

Abstract: A facility for defining a calculated distinguished database field is described. The facility receives a formula usable to calculate the value of the distinguished database field for each of a plurality of database rows, the formula expressed as a method in a distinguished procedural programming language. The facility transforms the formula method into a syntax tree for the distinguished procedural programming language. The facility modifies the syntax tree to provide variable context, field projection, runtimetype dynamic property accessors, and/or field path mapping. The facility transforms the modified syntax tree into a second version of the formula method in the distinguished procedural programming language.

Abstract: A facility for querying user-defined database columns is described. The facility receives a database query referring to one or more database columns, at least one of the referred-to database columns being a user-defined database column. The facility provides access to a database query result generated for the perceived database query via a programmatic object.

Abstract: A dynamic content system integrates dynamic and static content through entry of physical table and field structures and creating metadata describing the physical structures. A formula engine with a cascading formula detection engine calculates fields, and a dynamic meta-assembly engine dynamically generates code for the dynamic content. A dynamic meta-reporting engine with a dynamic meta-query engine reports content. An access control engine and workflow engine integrate into the dynamic content system to provide content permissions and routing.

Abstract: A dynamic content system integrates dynamic and static content through entry of physical table and field structures and creating metadata describing the physical structures. A formula engine with a cascading formula detection engine calculates fields, and a dynamic meta-assembly engine dynamically generates code for the dynamic content. A dynamic meta-reporting engine with a dynamic meta-query engine reports content. An access control engine and workflow engine integrate into the dynamic content system to provide content permissions and routing.