libsql execute does not return same result as ruslite execute

rusqlite:

    pub fn execute<P: Params>(&self, sql: &str, params: P) -> Result<usize> {
        self.prepare(sql)
            .and_then(|mut stmt| stmt.check_no_tail().and_then(|_| stmt.execute(params)))
    }

libsql:

    pub fn execute<S, P>(&self, sql: S, params: P) -> Result<Option<Rows>>
    where
        S: Into<String>,
        P: Into<Params>,

The return value for rusqlite is documented as:

On success, returns the number of rows that were changed or inserted or deleted (via sqlite3_changes).

If you expect rows with rusqlite, it looks like you have to use query on a statement.

Start by comparing libsql's execute API with the rusqlite execute contract described in the issue, then inspect how query on a statement handles returned rows. Done means execute has behavior and return semantics consistent with the documented rusqlite expectation, with coverage for changed, inserted, or deleted rows.