SQLite Forum

SQLite3 Array?
Login
is that what you want?

```
C:\Users\ddevienne>sqlite3
SQLite version 3.33.0 2020-08-14 13:23:32
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> with input(sud) as (values (53), (null), (7), (null), (null), (79))
   ...> select * from input;
53

7


79
sqlite>
```

I shortened the list, too tedious to type it all.  
I also assumed you wanted `null`s when you had nothing between commas.