SQLite: HasDefaultValueSql + ValueGeneratedOnAddOrUpdate loses default value

[rowanmiller]

public class MyContext : DbContext
{
    public DbSet<Blog> Blogs { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlite("Data Source=Sample.db");
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Blog>()
        .Property(b => b.Modified)
        .HasDefaultValueSql("CURRENT_DATE");
    }
}

public class Blog
{
    public int BlogId { get; set; }
    public DateTime Modified { get; set; }
}

Correctly adds a default value to the column...

CREATE TABLE "Blog" (
    "BlogId" INTEGER NOT NULL CONSTRAINT "PK_Blog" PRIMARY KEY AUTOINCREMENT,
    "Modified" TEXT NOT NULL DEFAULT (CURRENT_DATE)
)

Adding in a call to ValueGeneratedOnAddOrUpdate...

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Blog>()
    .Property(b => b.Modified)
    .HasDefaultValueSql("CURRENT_DATE")
    .ValueGeneratedOnAddOrUpdate();
}

Results in no default constraint...

CREATE TABLE "Blog" (
    "BlogId" INTEGER NOT NULL CONSTRAINT "PK_Blog" PRIMARY KEY AUTOINCREMENT,
    "Modified" TEXT NOT NULL
)

[ajcvickers]

Same root cause as #4501, so closing as duplicate.