boxlang-database-access

Parameterized queries in BoxLang prevent SQL injection by binding variables safely using queryExecute or bx:query. This approach separates SQL logic from data values, ensuring user input is treated strictly as data rather than executable code.

Datasource configuration in BoxLang is managed within boxlang.json or Application.bx files. You define connection properties directly in these configuration files, enabling structured setup for both main and read replicas across multiple datasources.

Yes, BoxLang database access fully supports managing transactions and invoking stored procedures. It provides structured patterns for transaction control and executing stored procedures across single or multiple configured datasources.

Handling multiple datasources in BoxLang involves configuring main and read replicas within boxlang.json or Application.bx. This setup enables efficient query load distribution by directing read operations to designated replica datasources.

Yes, BoxLang supports Query of Queries (QoQ) for in-memory data processing. This feature allows you to run SQL-like queries directly against existing result sets in memory, simplifying complex data manipulation workflows.