times

Represents the SQL * (multiplication) operator between two columns.

This operator function allows you to perform multiplication on two KQLiteColumn instances, which translates to column1 * column2 in the generated SQL. This is commonly used for numeric calculations, such as calculating total revenue from price and quantity.

Example

// SELECT (OrderDetails.quantity * OrderDetails.unitPrice) AS "line_total" FROM OrderDetails
OrderDetails.select(
    (OrderDetails.quantity * OrderDetails.unitPrice) AS "line_total"
)

Parameters

See also

Represents the SQL * (multiplication) operator between a column and a literal value.

This operator function allows you to multiply a KQLiteColumn by a literal value, which translates to column * value in the generated SQL. This is useful for calculations, such as applying a tax rate or a scaling factor.

Example

// SELECT (Products.price * 1.2) AS "price_with_vat" FROM Products
Products.select(
    (Products.price * 1.2) AS "price_with_vat"
)

Parameters

See also