Ad hoc query can be described as the ability to create a one-off, “on demand” report from BI or analytics software that answers a specific business question. This software decreases the workload to individually sorting out the answers, the software automatically detects business questions and answers them.
An ad hoc query is created to obtain information as the need arises. Contrast with a query that is predefined and routinely processed.
An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools.