Home → Active Query Builder → Programmatic modification of SQL queries

7. Programmatic modification of SQL queries

• 7.1. How to add object to the query programmatically
• 7.2. How to check all fields on adding an object to the query
• 7.3. How to add a relation programmatically
• 7.4. How to define aliases programmatically
• 7.5. How to modify WHERE clause programmatically
• 7.6. How to rename a table in the query programmatically
• 7.7. How to insert DISTINCT keyword into a query
• 7.8. How to add TOP clause to MS SQL Server query
• 7.9. How to add LIMIT clause to MySQL query
• 7.10. How to add FETCH FIRST to DB2 query
• 7.11. How to add/check ROWNUM condition in Oracle query