Generate PostgreSQL recursive CTEs for hierarchical data, graph traversal, running totals, and date series generation.
Provide your table schema, describe the query goal (e.g., org chart, bill of materials), specify the hierarchy structure, and set a max depth limit.
Initial release
Sign in and download this prompt to leave a review.