Add example with prepared statements

[ArBridgeman]

Summary

It looks like we are lacking examples & maybe coverage for our prepared statements.

import examples._config as config
import pyexasol

with pyexasol.connect(
        dsn=config.dsn,
        user=config.user,
        password=config.password,
        schema=config.schema,
        websocket_sslopt=config.websocket_sslopt,
) as conn:
    # Create table
    create_sql = """
    CREATE OR REPLACE TABLE "MARKETS" (
        "MARKET_ID" INTEGER,
        "POPULATION" VARCHAR(20)
    )
    """
    conn.execute(create_sql)

    data_rows = [
        (0, 'X6609676'),
        (1, 'X5080603')
    ]
    conn.ext.insert_multi('MARKETS', data_rows)

    sql = 'INSERT INTO "MARKETS" ("MARKET_ID", "POPULATION") VALUES (?, ?)'
    data = [[2, 'A6609676'], [3, 'B5080609']]

    with conn.cls_statement(conn, sql, prepare=True) as st:
        st.execute_prepared(data)

    select_sql = "SELECT * FROM MARKETS"
    results = conn.execute(select_sql)
    print(results.fetchall())