0.8.12

Added If, IfNotNull, and IfNotNullOrEmpty functions.

It's now easier to write dynamic search conditions.

int? price = null;
var query = SelectQuery.Parse(sql)
    .If(price != null, x => x.Equal(nameof(price), price));

by @mk3008 in #533

💣Serialization feature has been removed

We have discontinued it for the time being as the maintenance costs are not justified.

by @mk3008 in #534

Marked AddParameter as obsolete

We recommend using the parameter method.

by @mk3008 in #536

Supports ANY function parsing

SELECT
    s.unit_price * s.amount AS price
FROM
    sale AS s
WHERE
    s.unit_price * s.amount = ANY(:prices)

by @mk3008 in #538

Add support for ESCAPE keyword in LIKE clause parsing

WITH users AS (
  SELECT '30' as name
  UNION ALL
  SELECT '%30'
)
SELECT * FROM users WHERE name LIKE 'x%3%' escape 'x'

by @mk3008 in #541

Full Changelog

0.8.11...0.8.12