Use SELECT Queries Safely in AIQ SQL

Use SELECT Queries Safely in AIQ SQL

When using AIQ SQL in Scenario Editor or related test-data workflows, prefer explicit field lists over broad SELECT * patterns. Explicit fields make tests easier to maintain and reduce failures when schemas change.

Recommended query style

• Select only the columns needed by the test.
• Use clear aliases when values are mapped into scenario steps or DPL fields.
• Filter to the smallest safe data set for the validation.
• Avoid logging sensitive values in shared output.

Troubleshooting

1. Confirm the query runs in the approved database client or validation environment.
2. Check quoting rules for the database engine in use.
3. Review whether special characters are being interpreted by AIQ, the database, or the shell/script layer.

Last updated: September 8, 2026