Abstract: Various embodiments of systems and methods to validate relationships between entities are described herein. In one aspect, upon receiving a selection of an object associated with a source entity, a list of associations corresponding to the source entity is provided, where each association defining a related target entity. Further, upon receiving a selection of at least one association from the list of associations entity relationship data corresponding to the selected object is retrieved from destination entities defined by the at least one selected association. And, the retrieved entity relationship data is rendered on a computer generated user interface.

Abstract: Various embodiments of systems and methods for validating Structured Query Language (SQL) queries in a software programming language report during application development are described herein. The method involves receiving a selection of a specific SQL query in the report and automatically invoking a data preview editor interface. The selected query is rendered on the interface for execution. In an aspect, the selected query is parsed and a source part and a result part are extracted. Based on the extracted source part and result part, a data type definition and data declaration are automatically determined for the accessed data. Further, a dynamic subroutine is generated with the determined data type definition, data declaration, and the selected query and executed. A preview of the result of executing the dynamic subroutine is rendered in the data preview editor for validating the query.