# squarelibraries

Zoltan Demant

10/04/2023, 7:16 AM
`[SqlDelight]`: When using nullable list properties in a .sq file; the generated code incorrectly tries to use the ColumnAdapter for the list, instead of elements in it. Is this a bug or is my SQL not fluent enough?
Copy code
SELECT transactionSql.*
FROM transactionSql
LEFT JOIN categorySql ON transactionSql.categoryId =
WHERE (:accountIds IS NULL OR transactionSql.accountId IN :accountIds);
is nullable, and the problematic line.
Fwiw, trying to do "if Ive specified X, filter by it"