bi_sql_editor

Purpose

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.

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