I wonder why sqldelight 2.0.0 generate a nullable value here?

CREATE TABLE AnalysisHistoryEntry (
  id INTEGER NOT NULL PRIMARY KEY,
  ...
)

insertOrReplace:
INSERT OR REPLACE
INTO AnalysisHistoryEntry
VALUES (?, ?, ?, ?, ?, ?, ?);

generates:

public fun insertOrReplace(
    id: Long?,
    ...
  )

Is this a bug? Seeing this in all my tables.

Definitely a bug

Maybe try explicitly defining your columns in the insert statement, like:

insertOrReplace:
INSERT OR REPLACE
INTO AnalysisHistoryEntry (id, foo, bar, baz)
VALUES (:id, :foo, :bar, :baz);

I'll try, but still looks like a bug, because generator outputs "id: Long?", so it knows which column is which (by default), so it could derive its nullability

Yes, I agree. Might be worth a shot as a workaround.