v1.1.0 — Fixed and working version

v1.1.0 – Safer and More Usable Creatio SQL Console

This release focuses on improving safety, usability, and visual clarity of the in-app SQL Console.

Backend changes

• Added permission check via a dedicated system operation CanUseSQLConsole
  Only users with this operation can execute queries from the console.
• Introduced a hard limit of 5000 rows for SELECT queries.
  If the result set exceeds this limit, the service returns a clear error message instead of streaming all rows.
• Implemented query logging: every unique SQL text is saved to the iaSQLConsole table together with the user and timestamp.
• Added a basic SQL safety filter that blocks dangerous commands:
  • DROP
  • DELETE
  • TRUNCATE
    (and related variations)
    These commands are not executed via the console.
• Simplified the service API to accept raw queryText (unencrypted) directly from the UI.

Frontend changes

• Added client-side column sorting:
  • click a column header to sort ascending,
  • click again to toggle descending,
  • clicking another column switches sorting to that column.
• Improved table styling for better readability:
  • dark grey header with white text,
  • alternating grey/white row background (striped table),
  • subtle grid lines between rows and columns.
• Kept support for:
  • pagination,
  • date formatting for /Date(...) values,
  • CSV export for query results.

Safety note

This tool is still powerful and is intended primarily for development / non-production environments.
For production, use it with extreme care and only for trusted technical users with the proper operation assigned.

v1.0.0 — Initial public release

Highlights

Standalone bundle - Angular 17, CodeMirror 6, Crypto-JS, Material 17. No CDN, no assets.
SQL editor with syntax highlighting, keyboard shortcuts (Ctrl/⌘ + Enter, Ctrl/⌘ + X).
Encrypted traffic - AES-256 ECB + PKCS#7 using SysSetting iaSQLSecret.
Dynamic result table

• Column auto-detection
• In-table horizontal & vertical scroll
• Client-side sorting on header click
• Pagination (customizable pageSize, default 100)

Export to CSV - one-click download of the full result set.
Date parser - converts /Date(…)/ to YYYY-MM-DD HH:MM:SS.
Freedom-UI styling - inherits Creatio 8.2+ variables, supports light/dark.