An ad hoc query is a one-time, user-defined request for information from a database, often used to answer a specific business question. Ad hoc queries are a cornerstone of BI, enabling analysts and business users to explore data beyond predefined report.