SQLite TypeHandler not called

Used the following handler with SQL-Server, works as expected.

public class DateOnlyTypeHandler : SqlMapper.TypeHandler<DateOnly>
{
    public override void SetValue(IDbDataParameter parameter, DateOnly date)
    {
        parameter.Value = date.ToString("yyyy-MM-dd");
    }

    public override DateOnly Parse(object value)
        => DateOnly.FromDateTime((DateTime)value);
}

Setup

internal class DapperOperation
{

    private readonly IDbConnection _cn;

    public DapperOperation()
    {
        _cn = new SqlConnection(ConnectionString());
        SqlMapper.AddTypeHandler(new SqlDateOnlyTypeHandler());
    }

Problem

Tried this with SQLite.Core with SQLiteConnection and neither SetValue nor Parse are executed which I learned by a) inspecting values sent to the database b) setting breakpoints.

• Dapper 2.1.44
• System.Data.SQLite.Core 1.0.118
• VS2022 17.9.2
• NET8

Start by reproducing the report with SQLiteConnection and the DateOnlyTypeHandler registered through SqlMapper.AddTypeHandler. Trace SetValue and Parse while comparing the SQLite behavior with the reported SQL Server behavior; done means both handler callbacks are invoked as expected for SQLite.