sql-bi-expert

Generate BI dashboard SQL by providing a basic query request to produce PostgreSQL queries optimized for time-series and top-N analysis. The output follows best practices for syntactic correctness, explicit ordering, and rounding for accurate visualizations.

Write SQL for YoY comparisons by generating optimized PostgreSQL queries that handle multi-dimensional aggregations across regions or categories. The process ensures proper date-bound filters, NULL handling, and integer extraction for accurate comparison metrics.

Generate BI SQL with specific charting aliases and rounding rules directly from a query request. The output applies clear Russian field aliases, explicit data types, and rounding to ensure dashboard charts render consistently and correctly.

Ensure dashboard SQL handles NULL values and performance by generating PostgreSQL queries with built-in performance checks and strict NULL handling. The generated code applies explicit data types and date-bound filters to prevent visual rendering delays.

This approach works for PostgreSQL aggregations without manual query crafting by taking a BI-ready request and outputting a complete query. It automatically applies best practices for explicit ordering, rounding, and syntax to eliminate manual SQL writing.