Revise Truncate with regards to autoincrement reset and returned value

Problem/Motivation

Follow up to ✨ [PP-1] Introduce a Connection::executeDdlStatement method Active .

As noted in the parent issue, Truncate is

• resetting the autoincrement value of the table
• returning inconsistent value depending on whether it executes via a DELETE or a TRUNCATE SQL statement

Steps to reproduce

Proposed resolution

tbd

Remaining tasks

User interface changes

Introduced terminology

API changes

Data model changes

Release notes snippet