Query Sheet Limitations

The Query Sheet supports common query operations and advanced SQL execution, but certain SQL statements, query modes, data restrictions, and browser compatibility requirements limit how queries run and how results are accessed.

Limitations

S.No.	Limitation	Description	Resolution/Workaround
1	SQL DECLARE Statements	The Query Sheet does not support SQL DECLARE statements. Queries that use variable declarations may return an “Invalid Query” message, even if they execute successfully in SQL Server.	Replace variable declarations with direct values or rewrite the query without DECLARE statements.
2	Unsupported SQL Functions and Statements	The Query Sheet does not support certain SQL functions and statements, such as CAST and SET. Queries containing these functions or statements may fail to execute.	Review the query and rewrite it using supported SQL syntax.
3	Query Result Downloads	Query results can be downloaded only in Advanced SQL mode. The download option is not available in Auto SQL mode. Download requests are processed as background jobs, and the generated file becomes available after the job completes.	Use Advanced SQL mode to download query results. Wait for the background job to complete before accessing the generated file.
4	Queries on Tables with Masked Columns	The Query Sheet does not allow queries on tables that contain masked columns. Query execution is blocked to prevent access to restricted data.	Query tables that do not contain masked columns.
5	Firefox Compatibility	Query results may not appear in the Query Sheet when using Firefox.	Upgrade Firefox to the latest version that supports HTML5 and the SpreadJS plugin. This issue does not occur in Google Chrome.

Query Sheet System Settings

Key	Description
ovaledge.query.restrict.uncrawled.ovaledgedb	This system setting controls whether the Query Sheet allows users to query uncrawled objects managed by OvalEdgeDB. It gives administrators an option to restrict access to these objects until they are crawled. Parameters: Default value: true True: Restricts querying on OvalEdgeDB uncrawled objects. False: Allows users to query OvalEdgeDB uncrawled objects without this restriction.

Example:

Restrict querying on uncrawled objects

• When ovaledge.query.restrict.uncrawled.ovaledgedb is set to true, the Query Sheet restricts querying on OvalEdgeDB objects that have not been crawled.

• For example, an OvalEdgeDB table named customer_orders has not been crawled. A user selects the table in the Query Sheet and attempts to execute a query. The query is restricted because the object hasn't been crawled.

Allow querying on uncrawled objects

• When ovaledge.query.restrict.uncrawled.ovaledgedb is set to false, the Query Sheet allows users to query OvalEdgeDB uncrawled objects without this restriction.

• For example, an OvalEdgeDB table named customer_orders has not been crawled. A user selects the table and executes a query. The query is allowed because the restriction is disabled.

Key	Description
ovaledge.query.restrict.uncrawled.objects	Controls whether users can query objects that have not yet been crawled into the OvalEdge platform. This setting helps administrators control access to uncrawled objects through the Query Sheet. Parameters: Default value: true true: Restricts querying on uncrawled objects. false: Allows users to query uncrawled objects without this restriction.

Example:

Consider a table named CUSTOMER_DETAILS that exists in the remote database but has not yet been crawled into OvalEdge.

• When the setting is true: Users cannot query CUSTOMER_DETAILS through the Query Sheet until the object is crawled.

• When the setting is false: Users can query CUSTOMER_DETAILS through the Query Sheet even though the object has not been crawled.

This setting controls restrictions on uncrawled objects. It does not change the requirement for users to have the necessary permissions to access and query the data.

Key

Description

query.sheet.readonly.restriction.enabled

Enforces read-only restrictions in the Query Sheet module. When enabled, the Query Sheet permits only SELECT queries and blocks data modification and other SQL operations. Parameters: Default value: true true: Allows only SELECT queries. Blocks INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, TRUNCATE, and other data modification operations. false: Allows all query operations supported by the connector and permitted by the source system.

Example:

Read-only restriction enabled

• When query.sheet.readonly.restriction.enabled is set to True, users can execute queries that retrieve data but cannot modify the source data.

• The query executes successfully and displays the results.

  SELECT * FROM customers;

• The query is blocked because UPDATE modifies data.

  UPDATE customers
  SET status = 'Inactive'
  WHERE customer_id = 1001;

Read-only restriction disabled

• When the setting is set to False, the Query Sheet allows query operations supported by the connector and permitted by the source system.

• The query can execute if the connector supports UPDATE and the user has the required permissions in the source system.

  UPDATE customers
  SET status = 'Inactive'
  WHERE customer_id = 1001;

Setting this parameter to False is not recommended for production environments because it allows data modification operations through the Query Sheet.

---

Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA.