Bug: prepared statement execute() returns Result object for all queries

[kenjis]

Describe the bug
In the CI4 spec, query() returns bool for write-type queries.
But the current implementation of execute() returns Result object for all queries.

Isn't it a bug?

See #4176 (comment).

CodeIgniter 4 version
develop branch.

Affected module(s)
Database

Expected behavior, and steps to reproduce if appropriate
The same as query() return value.

[michalsn]

Yes, for write-type queries we should have a boolean result.

[sclubricants]

Does #6750 close this?

[kenjis]

Yes.

[kenjis]

Closed by #6750