[SQL] how do I count all the column NULL values in the table without manually entering each column name?

I want to calculate how many NULL there are in each column of the table. But I don"t want to write as:

SELECT SUM(CASE WHEN columns1 IS NULL THEN 0 ELSE 1),
       SUM(CASE WHEN columns2 IS NULL THEN 0 ELSE 1),
       SUM(CASE WHEN columns3 IS NULL THEN 0 ELSE 1),
       SUM(CASE WHEN columns4 IS NULL THEN 0 ELSE 1),
       .....
FROM table

is there any good idea? Using SQLite.

Sqlite sql

Jul.19,2022

subquery, query all column names, and then surround it with the column names just looked up by for...in, okay?

Previous: What is the reason why nginx cannot implement regular batching?

Next: The pit that axios encountered when uploading file files, no multipart boundary was found

Does beego have any other sqlite libraries that support cgo?
[root@host up]-sharp . main [ORM]2018 10 02 01:48:15 register db Ping `default`, Binary was compiled with CGO_ENABLED=0 , go-sqlite3 requires cgo to work. This is a stub must have one register DataBase alias named `default` [root@host up]-sharp ...

Sqlite sql golang

Jul.29,2021