Overview
In legacy Construct, Text Area fields could be configured with SQL format that provided syntax highlighting and formatting for SQL text display. The Formatted SQL field feature was specifically used by:
Admin and metadata management pages
Pages displaying stored procedures, views, or query definitions
Cloud Construct does not have built-in SQL syntax highlighting, but you can display SQL as a read-only plain text in a multi-line Text Area field.
Updated Methodology
In Cloud Construct, formatted SQL display is not available. To allow users to view SQL statements (as plain texts) without editing:
Ensure the dataset column stores the SQL statement as text (nvarchar or nvarchar(max) for long queries).
Edit the required WebApp.
In the WebApp Builder, configure the column as a Text Area input type to support multi-line display.
Disable Support Update and Support Delete toggles to set the column as read-only. So users cannot modify the SQL.
Save and Preview the WebApp.
The field displays SQL as plain text in a multi-line text box. Users can read and copy the SQL for use in SQL Editor or external tools, for example, SSMS.