SQL Console

Runs one SQL statement directly against the catalogue database - useful for one-off fixes (e.g. correcting a provenance field) that don't need a full page built for them. SELECT/UPDATE/DELETE/INSERT/ ALTER/CREATE etc. are allowed; DROP and TRUNCATE are blocked, and only one statement may be run at a time. Every statement that changes data is written to the Audit Log; plain SELECT queries are not. Human Tissue Act classification (slides.hta_status and its companion columns, and the hta_status_audit_log table) cannot be changed here at all - use HTA Classification instead, so the change is properly logged. Visible to system administrators only.