Couchbase has released version 4.5 of its NoSQL database, introducing enhancements such as improved N1QL features, faster queries, indexing, and role-based security. Cloud9 Charts has integrated support for this new version to enable native Business Intelligence (BI) integration, leveraging these new features while maintaining compatibility with previous versions. Key improvements in this release include high-performance joins with Index-JOIN support, array indexing for better performance in queries involving arrays, and memory-optimized indexes for write-intensive workloads. A notable addition is the INFER command, which provides metadata of document structures and facilitates dynamic N1QL query generation. Cloud9 Charts utilizes this functionality to enhance its BI solutions, offering a point-and-click interface for generating N1QL queries, which supports JSON and offers SQL-like familiarity. This integration aims to maximize the potential of N1QL for users of Couchbase.