1  .param(v).param(v)                  ? placeholders  -> [Mechanical Keyboard]
2  .param(1, v)                        by index        -> [Mechanical Keyboard]
3  .params(List.of(..))                ? placeholders  -> [Wireless Mouse, Headset]
4  .param("sku", v)                    :named          -> [Mechanical Keyboard]
5  .params(Map.of(..))                 :named          -> [Mechanical Keyboard]
6  .paramSource(record)                :named, record  -> [Mechanical Keyboard]
7  :p used twice, one .param("p", 10)  :named          -> [KB-001, MS-002]
8  IN (:skus) with a 3-element list    expanded        -> [KB-001, WC-005] (NOPE matched nothing)
9  LIKE :q with "%o%"                 wildcard in value -> [Mechanical Keyboard, Wireless Mouse, Monitor 27 inch]

10 :named and ? in one statement    -> java.lang.IllegalStateException: Configure either named or indexed parameters, not both
11 typo in the parameter name (:sku, supplied skuu) -> org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'sku': No value registered for key 'sku'
12 two ? but one value                  -> org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT name FROM product WHERE sku = ? AND in_stock = ?]; Parameter "#2" is not set; SQL statement: SELECT name FROM product WHERE sku = ? AND in_stock = ? [90012-240]  [root cause: JdbcSQLDataException: Parameter "#2" is not set; SQL statement: SELECT name FROM product WHERE sku = ? AND in_stock = ? [90012-240]]
13 .param("sku", null)                  -> ran, rows: 0 (= NULL is never true)
   .param("sku", null, Types.VARCHAR)   -> ran, rows: 0 (= NULL is never true)
