Hi,

if we run a

pragma table_info(t1);

where t1 is a table with 'Generated Columns' we get list of only ordinary columns, ie generated column(s) are not displayed, even if STORED option is used.

So, there is a need to use

pragma table_xinfo(t1);

statement to get result that includes all columns - regular and generated (computed) ones.

I think that this behavior should be documented in Generated Columns article, and also in pragma table_xinfo.