query.result.add(query.columns.custname.abs)

/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.asc)
.add(query.columns.companyid)
foundset.loadRecords(query)

/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.avg.eq(1))
	foundset.loadRecords(query)

query.result.add(query.columns.custname.bit_length)

query.result.add(query.columns.mycol.ceil)

/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
	foundset.loadRecords(query)

query.result.add(query.columns.mydatecol.day)

/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.desc)
.add(query.columns.companyid)
foundset.loadRecords(query)

query.result.add(query.columns.mycol.floor)

query.result.add(query.columns.mydatecol.hour)

query.where.add(query.columns.flag.isNull)

query.result.add(query.columns.custname.len)

query.result.add(query.columns.custname.lower)

/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.max(10))
	foundset.loadRecords(query)

/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.min(10))
	foundset.loadRecords(query)

query.result.add(query.columns.mydatecol.minute)

query.result.add(query.columns.mydatecol.month)

query.where.add(query.columns.flag.not.eq(1))

/** @type {QBSelect<db:/example_data/person>} */
	var query = databaseManager.createSelect('db:/example_data/person')
	query.where.add(query.joins.person_to_parent.joins.person_to_parent.columns.name.eq('john'))
	foundset.loadRecords(query)

/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')

 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.where.add(query
		.or
			.add(query.columns.order_id.not.isin([1, 2, 3]))

			.add(query.exists(
					subquery.where.add(subquery.columns.orderid.eq(query.columns.order_id)).root
			))
		)

	foundset.loadRecords(query)

query.result.add(query.columns.mycol.round)

query.result.add(query.columns.mydatecol.second)

query.result.add(query.columns.custname.sqrt)

/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
	.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.sum(10))
	foundset.loadRecords(query)

query.result.add(query.columns.custname.trim)

query.result.add(query.columns.custname.upper)

query.result.add(query.columns.mydatecol.year)

query.where.add(query.columns.flag.between(0, 5))

query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER))

query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname))

query.result.add(query.columns.mycol.divide(2))

query.where.add(query.columns.flag.eq(1))

query.where.add(query.columns.flag.ge(2))

query.where.add(query.columns.flag.gt(0))

query.where.add(query.columns.flag.isin(query2))

query.where.add(query.columns.flag.isin([1, 5, 99]))

query.where.add(query.columns.flag.le(2))

query.where.add(query.columns.companyname.like('Serv%'))

query.where.add(query.columns.companyname.like('X_%', '_'))

query.result.add(query.columns.mycol.locate('sample'))

query.result.add(query.columns.mycol.locate('sample', 5))

query.where.add(query.columns.flag.lt(99))

query.result.add(query.columns.mycol.minus(2))

query.result.add(query.columns.mycol.mod(2))

query.result.add(query.columns.mycol.multiply(2))

query.result.add(query.columns.mycol.nullif('none'))

query.result.add(query.columns.mycol.plus(2))

query.result.add(query.columns.mycol.substring(3))

query.result.add(query.columns.mycol.substring(3, 2))