private function resolvePreparedStatement($query = '', array $parameters = [])
    {

        // the instance of database connection
        $connection = $this->getConnection();
        $prepare = $connection->prepare($query);

        if ($prepare instanceof PDOStatement) {
            $resolved = $this->resolvePdoPreparedStatement($prepare, $parameters);
        } elseif ($prepare instanceof mysqli_stmt) {
            $resolved = $this->resolveMysqliPreparedStatement($prepare, $parameters);
        }

        return [$prepare, $resolved];
    }