2.2.0

sqllin-dsl

• New experimental DSL API: DatabaseScope#CREATE_INDEX for creating indexes
• New experimental DSL API: DatabaseScope#CREATE_UNIQUE_INDEX for creating unique indexes
• New experimental DSL API: DatabaseScope#PRAGMA_FOREIGN_KEYS for enabling foreign keys
• New experimental annotation APIs: ForeignKeyGroup, References, ForeignKey for supporting foreign keys for table and column levels
• New experimental annotation API: @Default for specifying default values for columns in CREATE TABLE statements
• New SQL aggregate function: group_concat for concatenating values with a separator
• New SQL scalar functions: round, random
• New SQL string functions: substr, trim, ltrim, rtrim, replace, instr, printf
• New overload for length function to support ClauseBlob type
• Breaking change: The parameter type of abs function changed from ClauseElement to ClauseNumber
• Breaking change: The parameter type of upper function changed from ClauseElement to ClauseString
• Breaking change: The parameter type of lower function changed from ClauseElement to ClauseString
• Breaking change: The parameter type of length function changed from ClauseElement to ClauseString

sqllin-driver

• Update the sqlite-jdbc's version to 3.51.1.0

sqllin-processor

• Update KSP's version to 2.3.3

2.1.0

sqllin-dsl

• Support typealias of supported types(primitive types, String, ByteArray etc) in generated tables
• Support enumerated types in DSL APIs, includes =, !=, <, <=, >, >= operators
• Support <, <=, >, >=, IN, BETWEEN...AND operators for String
• Support =, !=, <, <=, >, >=, IN, BETWEEN...AND operators for ByteArray
• Add a new condiction function ISNOT for Boolean, and IS starts to support to receive a nullable parameter
• Refactored CREATE statements building process, move it from runtime to compile-time.
• New experimental API for COLLATE NOCASE keyword: CollateNoCase
• New experimental API for single column with UNIQUE keyword: Unique
• New Experimental API for composite column groups with UNIQUE keyword: CompositeUnique

2.0.0

All

• Update Kotlin's version to 2.2.21
• Remove the Desuger configuration
• Update minimal supported Android version from API 23 to 24

sqllin-dsl

• Optimized performance for SQL assembly
• New annotation for marking primary key: PrimaryKey
• New annotation for marking composite primary key: CompositePrimaryKey
• New experimental API for creating Database: DSLDBConfiguration
• New experimental DSL API: DatabaseScope#CREATE
• New experimental DSL API: DatabaseScope#DROP
• New experimental DSL API: DatabaseSceop#ALERT
• Support using ByteArray in DSL, that represents BLOB in SQLite

sqllin-driver

• Update the sqlite-jdbc's version to 3.50.3.0
• Breaking change: The data type of bindParams in DatabaseConnection#query changed from Array<out String?>? to Array<out Any?>?

sqllin-processor

• Update KSP's version to 2.3.0

1.4.4

All

• Update Kotlin's version to 2.2.0

sqllin-dsl

• Update kotlinx.serialization's version to 1.9.0

sqllin-driver

• Update the sqlite-jdbc's version to 3.50.2.0

sqllin-processor

• Update KSP's version to 2.2.0-2.0.2

1.4.3

v1.4.3 / 2025-06-02

All

• Update Kotlin's version to 2.1.21

sqllin-processor

• Update KSP's version to 2.1.21-2.0.1

1.4.2

All

• Update Kotlin's version to 2.1.20

sqllin-dsl

• Update kotlinx.coroutines's version to 1.10.2
• Update kotlinx.serialization's version to 1.8.1

sqllin-driver

• Update the sqlite-jdbc's version to 3.49.1.0

sqllin-processor

• Update KSP's version to 2.1.20-1.0.32

1.4.1

All

• Update Kotlin's version to 2.1.10

sqllin-dsl

• Update kotlinx.coroutines's version to 1.10.1
• Update kotlinx.serialization's version to 1.8.0
• Add some DslMaker annotations, make the DSL apis be more readable

sqllin-driver

• Update the sqlite-jdbc's version to 3.48.0.0

sqllin-processor

• Update KSP's version to 2.1.10-1.0.29

1.4.0

All

• Update Kotlin's version to 2.1.0

sqllin-dsl

• Update kotlinx.coroutines's version to 1.9.0
• Update kotlinx.serialization's version to 1.7.3

sqllin-driver

• Update the sqlite-jdbc's version to 3.47.1.0

sqllin-processor

• Update KSP's version to 2.1.0-1.0.29

1.3.2

All

• Update Kotlin's version to 1.9.24

sqllin-dsl

• Now, you can annotate properties with kotlinx.serialization.transmint in your data classes to ignore these properties when serialization or deserialization and Table classes generation.

sqllin-processor

• Update KSP's version to 1.9.24-1.0.20

1.3.1

sqllin-dsl

• Fix a crash when a data class doesn't contain any String element.
• Fix the issue#81 about insert and query null values
• Fix some wrongs about generation of SQL syntax

sqllin-driver

• Breaking change: Remove the deprecated API CommonCursor#forEachRows
• Breaking change: the getInt, getLong, getFloat and getDouble will throw an exception when the value is NULL in SQLite on JVM and native platforms, like on Android in older versions.
• Add a new public API: CommonCursor#isNull, for check if the value is NULL in SQLite