A recursive query is a type of SQL query that refers to itself in its own definition, allowing for the retrieval of hierarchical or transitive data structures, such as organizational charts or bill of materials. It is typically implemented using Common Table Expressions (CTEs) with a base case and a recursive step, enabling efficient querying of data with unknown depth.