bi_sql_editor
This module enables the creation of custom Business Intelligence (BI) reports by allowing users to write SQL queries that generate views in Odoo, supporting both normal and materialized SQL views with automatic model and UI generation.
Key Features
- reporting: Allows writing and validating custom SQL queries to create database views
- reporting: Supports both normal and materialized SQL views for performance optimization
- reporting: Automatically maps SQL columns to Odoo field types with intelligent type guessing
- reporting: Generates Odoo models, fields, and access rules based on SQL view structure
- reporting: Creates complete UI components including list, graph, pivot, and search views
- reporting: Provides automatic menu and action creation for report access
- reporting: Implements security through group-based access control and domain restrictions
- reporting: Supports indexing on materialized views for improved query performance
- reporting: Enables group by operations and custom aggregation operators for numeric fields
- reporting: Allows customization of field visibility, graph types, and view contexts
- reporting: Includes cron-based automatic refresh for materialized views
- reporting: Provides preview functionality for SQL query results