[sqlite] Can SQLite know from the statement string if it is row producing or not?

[Luuk]

On 08-01-16 21:27, Bart Smissaert wrote:
> I am interested to know from the statement string if the statement is
> invalid, row producing (could produce rows) or non row producing. I know
> sqlite3_prepare16_v2 can see if the statement is valid or not but how about
> the other 2?
> I can do this in code no problem, but it may not always be 100% reliable
> for example there
> could be a new pragma or maybe some new SQL keyword.
>
>


What is you exact definition of 'row_producing' and 'non_row_producing'?

Will this statement be 'row_producing' or 'no_row_producing' or ...?:
INSERT INTO table1 VALUES(1);
if table1 is defined as 'CREATE TABLE table1(i INTEGER PRIMARY KEY);'

how does this change if the table was defined as:
CREATE TABLE table1(i);