zio/zio-quill
54.5
Adequate · 14 November 2026
23.6k
lines of production code
Scala
primary language
7
measurements over time
What this system is
Features
Add OrientDB support to ZIO Quill
This change introduces a new database context for OrientDB within the ZIO Quill library. It adds the \OrientDBContext\, \OrientDBSyncContext\, and \OrientDBMirrorContext\ classes, along with the \OrientDBIdiom\ for SQL translation and specific encoders/decoders for collections (List, Set, Map) and primitive types. The implementation includes a \Like\ DSL extension and handles OrientDB-specific constraints, such as the lack of transaction support and the \RETURNING\ clause. Comprehensive test coverage is provided for query execution, type encoding, and collection handling.
quill-orientdb · high confidence
Added Apple M1 build support with dedicated Dockerfiles and instructions
New Dockerfiles (Dockerfile-sbt and Dockerfile-setup) and a README have been added to the build/m1 directory to enable building and testing the project on Apple M1 hardware. The setup image installs necessary database clients (MariaDB, PostgreSQL, MSSQL, SQLite) and Cassandra, while the SBT image provides the Scala build environment with ARM64 platform support. Users can now follow the provided instructions to configure Docker Desktop resources and use the specific docker-compose-m1.yml file to run tests on M1 chips.
build/m1 · high confidence
Initial repository structure and development environment setup
The repository is initialized with the core project documentation (README, Code of Conduct, Apache 2.0 License) and essential configuration files for the build and development workflow. This includes \.scalafmt.conf\ for code formatting, \.gitignore\ to exclude build artifacts and IDE files, and \codecov.yml\ for coverage reporting. Additionally, Docker Compose files (\docker-compose.yml\, \docker-compose-m1.yml\) and helper scripts (\env.sh\, \debug\_sbt.sh\) are added to provide a standardized local environment for running integration tests against PostgreSQL, MySQL, Cassandra, OrientDB, SQL Server, and Oracle.
(repo-wide) · high confidence
Initial support for Spark SQL queries via Quill
This change introduces a new Spark SQL dialect and context within the \quill-spark\ module, enabling users to write Quill queries that execute against Apache Spark DataSets. The implementation includes a \SparkDialect\ that translates ASTs into Spark-compatible SQL (using constructs like \explode\ for \concatMap\ and \struct\ for tuples/case classes), along with specific encoders for primitive types and options, and a normalization pass to escape question marks in string literals to prevent SQL injection or parsing conflicts. Comprehensive test suites verify the correctness of joins, nested queries, type member joins, and encoding/decoding behaviors.
quill-spark · high confidence
Introduce JDBC code generator with composable trait generation and schema typing
The \quill-codegen-jdbc\ module now includes a new code generator that reads database schemas and produces Scala source code. It provides a \SimpleJdbcCodegen\ for generating basic case classes and a \ComposeableTraitsJdbcCodegen\ that generates traits (e.g., \PersonDao\) containing \querySchema\ definitions, which can be composed into custom Quill contexts. The generator automatically discovers the database type (e.g., MySQL, PostgreSQL, Oracle) and handles type mapping for JDBC columns, including strategies for handling unrecognized types and numeric preferences. It also supports custom naming strategies (snake\_case, literal) and namespacing to avoid collisions when combining schemas from different sources.
quill-codegen-jdbc · high confidence
Introduce ZIO-based JDBC context for PostgreSQL JSON handling
This change adds a new ZIO-integrated JDBC context (\quill-jdbc-zio\) that enables executing database queries using ZIO effects. Specifically, it introduces \PostgresJsonExtensions\ to support encoding and decoding of PostgreSQL \json\ and \jsonb\ columns into \JsonValue\ and \JsonbValue\ wrappers using \zio.json\. The module also provides context implementations for PostgreSQL, SQL Server, H2, MySQL, SQLite, and Oracle, along with ZIO layers for managing data sources and connections, allowing users to run Quill queries as \ZIO\[DataSource, SQLException, T\]\ or \ZIO\[Connection, SQLException, T\]\.
quill-jdbc-zio · high confidence
Introduce ZIO-based logging extensions and restructured core DSL components
This change adds a new \zio.logging.extensions\ module that provides file logging capabilities by inlining and adapting internal ZIO logging functions, allowing users to configure file-based logs without ZLayers. Additionally, the core query DSL is reorganized into a modular trait hierarchy (\CoreDsl\, \EncodingDsl\, \MetaDsl\, etc.) and introduces new implicit conversion mechanisms via \ImplicitQuery\ to support querying product types through function arguments, while establishing foundational types like \Quoted\ and \EntityQuery\ for the new macro-based quotation system.
quill-core/src/main · high confidence
New JDBC context implementations and array encoding support
This change introduces the \quill-jdbc\ module, providing concrete JDBC context classes for H2, MySQL, Oracle, PostgreSQL, SQL Server, and SQLite, along with a centralized \JdbcContextConfig\ for HikariCP data source management. It adds comprehensive support for encoding and decoding JDBC arrays (including strings, numbers, dates, and UUIDs) and implements database-specific optimizations, such as SQLite's transactional batch emulation and SQL Server's multi-row insert handling for returning keys.
quill-jdbc · high confidence
New ZIO-based Cassandra context and session support
This change introduces a new \quill-cassandra-zio\ module that provides a Cassandra context fully integrated with ZIO. It adds \CassandraZioContext\ and \CassandraZioSession\ to execute queries as ZIO effects, supporting both standard execution and streaming via \ZStream\. The module also includes a \Quill.Cassandra\ wrapper for idiomatic ZIO usage with dependency injection, along with comprehensive tests and example applications demonstrating the new API.
quill-cassandra-zio · high confidence
New script to simplify container setup
A new \scripts/start\_containers.sh\ script has been added to streamline the local development environment setup. Running this script automatically stops existing containers, rebuilds the images, and executes the \setup\ service with port mappings enabled, reducing the manual steps required to initialize the 'All In One' environment.
scripts · high confidence
Behavioural changes
3 commits (1 fix) modifying quill-engine
A change to existing behaviour in quill-engine — 3 commits (1 fix), 75 files: “fix: correct wrong column references in flat join filters and correlated subqueries (\#3456)”; “Apply the naming strategy to EXCLUDED columns in onConflictUpdate (\#3455)”; “Rename package io.getquill to zio.quill (\#3442)” (refs \#3456, \#3455, \#3442).
quill-engine · medium confidence · unverified
3 commits (1 fix) modifying repository
A change to existing behaviour in repository — 3 commits (1 fix), 70 files: “fix: correct wrong column references in flat join filters and correlated subqueries (\#3456)”; “Return the updated row from Postgres batch updates (\#3457)”; “Rename package io.getquill to zio.quill (\#3442)” (refs \#3456, \#3457, \#3442).
repository · medium confidence · unverified
Introduce ZIO-based Cassandra context with UDT and collection support
The \quill-cassandra\ module has been refactored to use the \com.datastax.oss.driver.api.core.CqlSession\ from the DataStax Java Driver 4.x, replacing the previous session implementation. This change introduces new context classes (\CassandraAsyncContext\, \CassandraSyncContext\) that manage statement preparation and execution using the new driver API. Users gain support for Cassandra User-Defined Types (UDTs) with macro-based encoding/decoding, including nested collections within UDTs, as well as explicit encoding for \Byte\ and \Short\ types. The module also adds DSL operations for Cassandra-specific features like \ALLOW FILTERING\, \IF NOT EXISTS\, and TTL/Timestamp usage.
quill-cassandra · high confidence
Migrate Cassandra context to Apache Pekko
The Cassandra integration in the \quill-cassandra-pekko\ module has been migrated from Akka to Apache Pekko. This change updates the underlying \CassandraPekkoContext\ implementation to use \org.apache.pekko\ libraries for session management and streaming, and includes updated test suites and configuration to validate the new Pekko-based behavior.
quill-cassandra-pekko · high confidence
New build infrastructure with Dockerized database environments and CI scripts
The build system has been restructured to include dedicated Dockerfiles for Cassandra, SBT, setup, and SQL Server, alongside a suite of shell scripts (build.sh, setup\_databases.sh, setup\_db\_scripts.sh, etc.) that automate the provisioning of test databases (PostgreSQL, MySQL, Oracle, SQL Server, Cassandra, SQLite) via Docker Compose. This change introduces a standardized, containerized environment for running tests and builds, replacing previous ad-hoc setup methods.
build · high confidence
Package renamed from io.getquill to zio.quill
The library's root package has been renamed from \io.getquill\ to \zio.quill\. This change affects all source files, including the Cassandra ZIO session implementation, JDBC code generation models and generators, and core mirror contexts, requiring users to update their import statements to the new \zio.quill\ namespace.
(repo-wide) · high confidence
Removal of legacy SQL query rendering and source macro components
The SQL module has removed several internal components that were responsible for rendering SQL queries and handling the source macro execution: \ExprShow\, \SqlQuery\, \SqlQueryShow\, \SqlSource\, and \SqlSourceMacro\. These deletions indicate a significant refactoring of the SQL generation pipeline, likely replacing the previous AST-based query flattening and string-showing logic with a new implementation.
quill-sql/src/main/scala/io · high confidence
Test coverage
2 commits adding/updating tests in quill-jdbc-test-postgres, quill-test-kit; 5 commits adding/updating tests in quill-sql-test; Added JDBC context tests for H2, MySQL, and Oracle; Added test suite for ZIO Quill core; Removed obsolete People test file.
Dependencies
Build infrastructure modernized with SBT 1.11.4 and updated plugins
The project's build system has been upgraded from SBT 0.13.8 to 1.11.4, requiring users to ensure their local SBT installation is compatible. Several legacy plugins (Play, native-packager, sbt-codacy-coverage, sbteclipse, sbt-release) have been removed and replaced with modern equivalents: sbt-scalafmt (2.5.5) for formatting, sbt-scoverage (2.3.1) for coverage, sbt-mima-plugin (1.1.4) for binary compatibility checks, sbt-compile-quick-plugin (1.4.0) for faster compilation, zio-sbt-website (0.7.0) for documentation, and sbt-ci-release (1.11.1) for releases. Additionally, a new \project/Dependencies.scala\ file was introduced to centralize version management, currently setting ZIO to 2.1.20.
project · high confidence
Migrate documentation build to ZIO monorepo and restructure SBT build
The documentation build now uses the \@zio.dev/zio-quill\ npm package, reflecting the project's rebranding from GetQuill to ZIO Quill. The SBT build has been significantly restructured to support the new multi-module layout, introducing distinct module groups for base, database, code generation, and big data components. It adds explicit cross-building support for Scala 2.13 and Scala 3, and updates the \quill-util\ module to use \scalafmt-core\ version 3.9.4 with specific exclusions for Scala 3 compatibility.
(dependencies) · high confidence
Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.
How this codebase got here
Score
- CAI 58 → 55 (-3.7)
- Rubric changed (rubric-2026.10.5 → rubric-2026.11.4) — scores are not directly comparable.
Lenses
- Code Health 64 → 63 (-0.9)
- Architecture 91 → 99 (+8.0)
- Maturity 51 → 52 (+0.1)
- Readiness 59 → 61 (+2.1)
- Security 64 → 46 (-17.9)
- Performance 82 → 100 (+18.3)
Resolved (12)
- Duplicated block (5 lines × 2) (quill-engine/src/main/scala/zio/quill/MirrorIdiom.scala)
- Duplicated block (5 lines × 2) (quill-engine/src/main/scala/zio/quill/OracleDialect.scala)
- Duplicated block (5 lines × 2) (quill-engine/src/main/scala/zio/quill/sql/idiom/SqlIdiom.scala)
- Duplicated block (8 lines × 2) (quill-engine/src/main/scala/zio/quill/idiom/ReifyStatement.scala)
- Duplicated block (8–14 lines × 2) (quill-engine/src/main/scala/zio/quill/SqliteDialect.scala)
- Orphaned file (quill-engine/src/main/scala/zio/quill/PostgresDialect.scala)
- Orphaned file (quill-engine/src/main/scala/zio/quill/norm/ApplyMap.scala)
- Orphaned file (quill-engine/src/main/scala/zio/quill/sql/idiom/OnConflictSupport.scala)
- Orphaned file (quill-engine/src/main/scala/zio/quill/sql/norm/ExpandNestedQueries.scala)
- Outdated: com.typesafe.scala-logging:scala-logging_2.13
- Outdated: com.typesafe:config
- Projects may be oversized for their cohesion
New (35)
- Edited copies of one member (3 members, 13+ corresponding lines) (quill-jdbc/src/main/scala/zio/quill/context/jdbc/JdbcContextVerbExecute.scala)
- Edited copies of one member (3 members, 4+ corresponding lines) (quill-engine/src/main/scala/zio/quill/MySQLDialect.scala)
- Edited copy of a member (10 corresponding lines) (quill-jdbc-zio/src/main/scala-2.12/zio/quill/context/json/PostgresJsonExtensions.scala)
- Edited copy of a member (10 corresponding lines) (quill-jdbc-zio/src/main/scala-2.12/zio/quill/context/json/PostgresJsonExtensions.scala)
- Edited copy of a member (11 corresponding lines) (quill-cassandra-pekko/src/main/scala/zio/quill/CassandraPekkoContext.scala)
- Edited copy of a member (11 corresponding lines) (quill-engine/src/main/scala/zio/quill/ast/StatefulTransformer.scala)
- Edited copy of a member (13 corresponding lines) (quill-engine/src/main/scala/zio/quill/ast/StatefulTransformer.scala)
- Edited copy of a member (14 corresponding lines) (quill-engine/src/main/scala/zio/quill/ast/StatefulTransformer.scala)
- Edited copy of a member (17 corresponding lines) (quill-engine/src/main/scala/zio/quill/norm/RepropagateQuats.scala)
- Edited copy of a member (17 corresponding lines) (quill-engine/src/main/scala/zio/quill/sql/idiom/SqlIdiom.scala)
- Edited copy of a member (18 corresponding lines) (quill-core/src/main/scala/zio/quill/quotation/TranspileConfigSummoning.scala)
- Edited copy of a member (19 corresponding lines) (quill-codegen-jdbc/src/main/scala/zio/quill/codegen/jdbc/gen/DefaultJdbcSchemaReader.scala)
- Edited copy of a member (22 corresponding lines) (quill-engine/src/main/scala/zio/quill/context/cassandra/CqlIdiom.scala)
- Edited copy of a member (30 corresponding lines) (quill-engine/src/main/scala/zio/quill/ast/StatefulTransformer.scala)
- Edited copy of a member (36 corresponding lines) (quill-engine/src/main/scala/zio/quill/norm/AdHocReduction.scala)
- Edited copy of a member (4 corresponding lines) (quill-engine/src/main/scala/zio/quill/PostgresDialect.scala)
- Edited copy of a member (4 corresponding lines) (quill-engine/src/main/scala/zio/quill/context/cassandra/CqlIdiom.scala)
- Edited copy of a member (47 corresponding lines) (quill-engine/src/main/scala/zio/quill/ast/StatefulTransformer.scala)
- Edited copy of a member (5 corresponding lines) (quill-cassandra-pekko/src/main/scala/zio/quill/CassandraPekkoContext.scala)
- Edited copy of a member (5 corresponding lines) (quill-core/src/main/scala/zio/quill/context/mirror/MirrorEncoders.scala)
- …and 15 more
Changes since last survey
- 10 commits — 9 feature/other, 1 fixes
By area
- (root) — 5 commits
- .github/workflows — 2 commits
- quill-sql-test/src — 2 commits
- quill-engine/src — 1 commit
Notable commits
- fix: fix: correct wrong column references in flat join filters and correlated subqueries (#3456)
- change: Apply the naming strategy to EXCLUDED columns in onConflictUpdate (#3455)
- change: Return the updated row from Postgres batch updates (#3457)
- change: Update orientdb-graphdb to 3.2.58 (#3469)
- change: Update scala-logging to 3.9.6 (#3302)
- change: Update scala3-library to 3.3.9 (#3458)
- change: Update sqlite-jdbc to 3.54.1.0 (#3461)
- change: Update typesafe:config to 1.4.10 (#3466)
- change: Update zio-sbt-ci, zio-sbt-website to 0.8.7 (#3459)
- change: Update zio-sbt-ci, zio-sbt-website to 0.8.8 (#3468)
Architecture
- Unchanged — 0 containers · 1 contexts · 0 edges
Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.
Survey your own repository
zio/zio-quill was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.
About this page
- The score is its most recent published measurement, taken on 14 November 2026 at a pinned commit. It is not a live figure and does not change until the project is measured again.
- Measured at commit fc0800f45b73fa5e4638e669f5bca5a09fe57c21 — the exact code this score is about.
- Scored under rubric-2026.11.4 — the same rubric and the same method as every other entry in this index.
- Measured by Canine Code Analyzer (cca.canine.dev) using cca measure-2026.11.65+preprod-36d4cd83012f.