Checking if list is null leads to compile error

[3efischer]

Failing ANSI SQL

CREATE TABLE transactionEntity (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    transactionDate INTEGER AS ZonedDateTime NOT NULL,
    transactionType TEXT NOT NULL,
    accountId INTEGER,
    categoryId INTEGER,
);

SELECT *
FROM transactionEntity
WHERE :categoryIds IS NOT NULL AND categoryId IN :categoryIds;

Description

If :categoryIds is a list, this leads to an error since the first appearance is interpreted as a Long while the second is interpreted as Collection<Long?>.