Overview

Editions and features

Which Kiwi ORM features are free in the source-available edition and which are commercial (Enterprise).

ORM Current 3 min read Updated

Kiwi ORM has two tiers:

  • Free: the source-available edition. It contains the core foundation and the Raw SQL and Entity access modes, with the tooling around them.
  • Commercial: the Enterprise edition. It adds Repository mode, Managed CTEs, ready-made audit adapters and the compliance and access-governance controls. It is available for qualifying organisations.

Feature matrix#

Feature Free Commercial
Kiwi ORM Core: strongly typed pipeline, connection management, result mapping, cross-database abstraction Yes Yes
Raw SQL mode (KMQL): portable markup, typed parameter binding, automatic result mapping Yes Yes
Entity mode: CRUD without SQL, change tracking, relationship mapping, schema reflection, bulk operations Yes Yes
Repository mode: generic repository base, queries derived from method names, query composition, built-in pagination, unit-testable interfaces, dependency-injection registration No Yes
Sync and async execution Yes Yes
Stored procedure support (typed input, output, return values and multiple result sets) Yes Yes
Transaction management, including savepoints and isolation levels Yes Yes
11 supported database engines Yes Yes
Managed CTEs: standard and recursive, plus CTE-driven insert, update and delete No Yes
Schema lifecycle tooling: data-first entity generation, model-first migrations, drift detection, rollback Yes Yes
Source generators for entity boilerplate Yes Yes
Auditing hooks: the IAuditAdapter contract and UseAuditAdapter, so you can write your own audit code Yes Yes
Ready-made audit adapters: fully tested, zero-code adapters for all 11 relational databases, plus a MongoDB adapter No Yes
Query audit trail: every query logged with user, timestamp, parameters and result metadata No Yes
Sensitive-column redaction ([Sensitive]) in the audit trail Yes Yes
Pluggable audit destinations: send audit records to SIEM, Splunk or compliance tooling by implementing a custom IAuditAdapter Yes Yes
Data access policies: row-level and column-level controls enforced at the ORM layer No Yes
Compliance support for SOC 2, GDPR, HIPAA and ISO 27001 (technical controls to support applicable requirements) No Yes

Note

Repository mode, Managed CTEs, the ready-made audit adapters and audit trail, and access policies are Commercial. [Sensitive] redaction is applied by Core, so it works in the free edition too. The auditing hooks are part of the free Core: you can write your own audit code against them. The schema tooling carries no Enterprise label in Kiwify Labs' website or brochure and is therefore listed as free here. Confirm the exact entitlement of your licence with Kiwify Labs.

How the tiers show up in these docs#

Pages about Commercial features start with a Commercial feature notice, and pages about free features start with an Included in the free edition note. Where a page mixes both, each section says which it is.

Getting access#

Kiwi ORM is available under a source-available licence. To request access to the source, or an Enterprise enquiry, contact Kiwify Labs through kiwifylabs.com.