SQL.ResultMetadata.affectedRows

The number of rows that an INSERT, UPDATE, DELETE or MERGE wrote. 0 for a statement that writes nothing.

PostgreSQL tags CREATE TABLE AS, and a SELECT whose CTE writes, as SELECT, so it is 0 for them. MariaDB reports INSERT ... RETURNING as a result set, so it is 0 there too.