<!--
Welcome to Apache Airflow!

Please complete the next sections or the issue will be closed.
-->

**Apache Airflow version**: 2.1.0

<!-- AIRFLOW VERSION IS MANDATORY -->

**OS**: Raspbian GNU/Linux 10 (buster)

<!-- MANDATORY! You can get it via `cat /etc/oss-release` for example -->

**Apache Airflow Provider versions**: apache-airflow-providers-sqlite==1.0.2

<!-- You can use `pip freeze | grep apache-airflow-providers` (you can leave only relevant ones)-->

**Deployment**:  Virtualenv

<!-- e.g. Virtualenv / VM / Docker-compose / K8S / Helm Chart / Managed Airflow Service -->

<!-- Please include your deployment tools and versions: docker-compose, k8s, helm, etc -->

**What happened**:

When using the insert_rows function of the sqlite hook the generated parametrized sql query has an invalid syntax. It will generate queries with the %s placeholder which result in the following error:

*Query*: INSERT INTO example_table (col1, col2) VALUES (%s,%s)

*Error*:
sqlite3.OperationalError: near "%": syntax error

*Stacktrace*:
  File "/home/airflow/.pyenv/versions/3.8.10/envs/airflow_3.8.10/lib/python3.8/site-packages/airflow/hooks/dbapi.py", line 307, in insert_rows
    cur.execute(sql, values)

I replaced the placeholder with "?" in the _generate_insert_sql function DbApiHook as a test. This solved the issue.

<!-- Please include exact error messages if you can -->

**What you expected to happen**:

Every inherited method of the DbApiHook should work for the SqliteHook. Using the insert_rows method should generate the correct parametrized query and insert rows as expected.

<!-- What do you think went wrong? -->

**How to reproduce it**:

1. Create an instance of the SqliteHook
2. Use the insert_rows method of the SqliteHook

<!--
As minimally and precisely as possible. Keep in mind we do not have access to your cluster or dags.
If this is a UI bug, please provide a screenshot of the bug or a link to a youtube video of the bug in action
You can include images/screen-casts etc. by drag-dropping the image here.
-->

airflow/hooks/dbapi.py
#
#
#
from contextlib import closing
from datetime import datetime
from typing import Any, Optional
from urllib.parse import quote_plus, urlunsplit
from sqlalchemy import create_engine
from airflow.exceptions import AirflowException
from airflow.hooks.base import BaseHook
from airflow.typing_compat import Protocol
class ConnectorProtocol(Protocol):