string sql = "insert into customer values (1, 'Sir', 'John', 'Doe', " +
    "'1 Madison Ave', 'New York', 'NY 10010', NULL)";

using (AceQLCommand command = new AceQLCommand(sql, connection))
{
    int rows = await command.ExecuteNonQueryAsync();
    Console.WriteLine("Rows updated: " + rows);
}

Response:

Rows updated: 1

String sql = "insert into customer values (1, 'Sir', 'John', 'Doe', "
    + "'1 Madison Ave', 'New York', 'NY 10010', NULL)";

try (Statement statement = connection.createStatement();) {
    int rows = statement.executeUpdate(sql);
    System.out.println("Rows updated: " + rows);
}

Response:

Rows updated: 1

cursor = connection.cursor()
sql = "insert into customer values (1, 'Sir', 'John', 'Doe', '1 Madison Ave', 'New York', 'NY 10010', NULL)"
cursor.execute(sql,)
print("Rows updated: " + str(cursor.rowcount))

Response:

Rows updated: 1

let sql = "insert into customer values (1, \'Sir\', \'John\', \'Doe\', " 
           + "\'1 Madison Ave\', \'New York\', \'NY 10010\', NULL)"
		   
try connection.run(sql)
print("Rows updated: \(connection.changes())")

Response:

Rows updated: 1

string sql = "select customer_id, customer_title, lname from customer where customer_id = 1";

using (AceQLCommand command = new AceQLCommand(sql, connection))
using (AceQLDataReader dataReader = await command.ExecuteReaderAsync())
{
    while (dataReader.Read())
    {
        Console.WriteLine();
        int i = 0;
        Console.WriteLine("customer_id   : " + dataReader.GetValue(i++));
        Console.WriteLine("customer_title: " + dataReader.GetValue(i++));
        Console.WriteLine("lname         : " + dataReader.GetValue(i++));
    }
} 

Which returns:

customer_id   : 1
customer_title: Sir
lname         : Doe

String sql = "select customer_id, customer_title, lname from customer where customer_id = 1";

try (Statement statement = connection.createStatement();
    ResultSet rs = statement.executeQuery(sql);) {
    while (rs.next()) {

    System.out.println();
    int i = 1;
    System.out.println("customer_id   : " + rs.getInt(i++));
    System.out.println("customer_title: " + rs.getString(i++));
    System.out.println("lname         : " + rs.getString(i++));
    }
}

Which returns:

customer_id   : 1
customer_title: Sir
lname         : Doe

with closing(connection.cursor()) as cursor:
    sql = "select customer_id, customer_title, lname from customer where customer_id = 1"
    cursor.execute(sql)

    rows = cursor.fetchall()

    for row in rows:
        print("customer_id   : " + str(row[0]))
        print("customer_title: " + row[1])
        print("lname         : " + row[2])

Which returns:

customer_id   : 1
customer_title: Sir
lname         : Doe

let sql = "select customer_id, customer_title, lname from customer where customer_id = 1"
let stmt = try connection.run(sql)

for row in stmt {
    print("customer_id   : \(row[1])") 
    print("customer_title: \(row[2])")
    print("lname         : \(row[3])")
}

Which returns:

customer_id   : 1
customer_title: Sir
lname         : Doe

string sql = "update customer set fname = @fname where customer_id = @customer_id";

using (AceQLCommand command = new AceQLCommand(sql, connection))
{
    command.Prepare();
    command.Parameters.AddWithValue("@customer_id", 1);
    command.Parameters.AddWithValue("@fname", "Jim");

    int rows = await command.ExecuteNonQueryAsync();
    Console.WriteLine("Rows updated: " + rows);
}

Which returns:

Rows updated: 1

String sql = "update customer set fname = ? where customer_id = ?";

try (PreparedStatement prepStatement = connection.prepareStatement(sql);) {
    prepStatement.setString(1, "Jim");
    prepStatement.setInt(2, 1);

    int rows = prepStatement.executeUpdate();
    System.out.println("Rows updated: " + rows);
}

Which returns:

Rows updated: 1

cursor = connection.cursor()
sql = "update customer set fname = ? where customer_id = ?"
params = ("Jim", 1)
cursor.execute(sql, params)
print("Rows updated: " + str(cursor.rowcount))

Which returns:

Rows updated: 1

let  sql = "update customer set fname = ? where customer_id = ?"

let  stmt = try connection.prepare(sql)
try stmt.run("Jim", 1)
print("Rows updated: \(connection.changes())")

Which returns:

Rows updated: 1

await connection.CloseAsync();

connection.close();

connection.close()

connection.closeAsync() { status in }