TCK scenarios for Data 1.1

Nobody has claimed this yet.

List of TCK scenarios to cover for Jakarta Data 1.1

- [x] #964
- [x] #969
- [x] #997
- [x] #998
- [x] #1002
- [x] [TCK tests where JDQL query with SELECT clause of multiple entity attributes returned as a Java record](https://github.com/jakartaee/data/pull/1014/commits/bda1c709e982def22d4370ad93c9e5dffb142d38)
- [x] [TCK tests where JDQL query returns Java record type and record components determine the entity attribute (no SELECT or @Select is used)](https://github.com/jakartaee/data/pull/1014/commits/7b076d59b3bc494c41e095003619df671c6ed90c)
- [x] [TCK tests where JDQL query returns Java record type with Select annotation on record components](https://github.com/jakartaee/data/pull/1014/commits/73b6189e7c8c8b96cd5494d2682e1cc6d75c2999)
- [x] [`@First` annotation for at most 1 result.](https://github.com/jakartaee/data/pull/1441)
- [x] [`@First(max)` annotation for at most max results.](https://github.com/jakartaee/data/pull/1441)
- [x] #1511
- [x] [Sorting by expressions](https://github.com/jakartaee/data/pull/1497)
- [x] [Sort with nulls first and nulls last](https://github.com/jakartaee/data/pull/1432)
- [x] [OrderBy with nulls first and nulls last](https://github.com/jakartaee/data/pull/1435)
- [x] [Zero-based offset from first page](https://github.com/jakartaee/data/pull/1547)
- [x] [Stateful repository methods: `Detach`, `Merge`, `Persist`, `Refresh`, `Remove`](https://github.com/jakartaee/data/pull/1449)
- [x] [Pre/Post Insert life cycle event](https://github.com/jakartaee/data/pull/1530)
- [x] [Pre/Post Update life cycle event](https://github.com/jakartaee/data/pull/1530)
- [x] [Pre/Post Delete life cycle event](https://github.com/jakartaee/data/pull/1530)
- [x] [`jakarta.persistence.query.JakartaQuery` annotation on a repository method](https://github.com/jakartaee/data/pull/1551)
- [x] [`jakarta.persistence.query.NativeQuery` annotation on a repository method](https://github.com/jakartaee/data/pull/1495)
- [ ] [`jakarta.persistence.query.QueryOptions` annotation on a `Find` repository method](https://github.com/jakartaee/data/pull/1567)
- [ ] `jakarta.persistence.query.QueryOptions` annotation on a `Delete` repository method
- [ ] [`jakarta.persistence.query.QueryOptions` annotation on a `Query` repository method](https://github.com/jakartaee/data/pull/1567)
- [x] [`jakarta.persistence.query.QueryOptions` annotation on a `jakarta.persistence.query.JakartaQuery` repository method](#1561)
- [ ] [`jakarta.persistence.query.QueryOptions` annotation on a `jakarta.persistence.query.NativeQuery` repository method](https://github.com/jakartaee/data/pull/1567)
- [x] [Asynchronous repository methods](https://github.com/jakartaee/data/pull/1456)
- [x] [Asynchronous repository method exceptional completion](https://github.com/jakartaee/data/pull/1556)
- [x] [TCK tests for the `@Is` annotation](https://github.com/jakartaee/data/pull/1190)
- [x] [TCK tests for constraint subtype parameters (supplied with basic values, no expressions)](https://github.com/jakartaee/data/pull/1257)
- [x] [TCK tests of startsWith, endsWith, contains Restrictions and their negations](https://github.com/jakartaee/data/commit/1cb1ce287779aeb257ba660591a772cdbf32d982)
- [x] [TCK tests for isNull and notNull restrictions](https://github.com/jakartaee/data/commit/ee7e6837764e14ad0d70d18e4d9af0eeea29d1b0)
- [x] [TCK tests for In and NotIn restrictions](https://github.com/jakartaee/data/commit/b3c158ecd396f704b7fa00b739745e433712542f)
- [x] [basic equality/inequality tests for Restriction](https://github.com/jakartaee/data/commit/01059e354d18ce55cd47cc94e9ca6c29cfddf654)
- [x] [TCK tests for restrictions on a TemporalAttribute](https://github.com/jakartaee/data/commit/aaf9c694e2ca69fdfdb8e2082a2c7430de449e8b)
- [x] [TCK test for a Restriction on a BooleanAttribute](https://github.com/jakartaee/data/commit/a10dc2efe106fc12eb982413b4bbae8c4e5333a2)
- [x] [TCK tests for negated ALL and negated ANY](https://github.com/jakartaee/data/commit/9eb409dfe1b21010c05a86f459a9884c6ff758e9)
- [x] [TCK tests for depth 2 hierarchy of composite restrictions](https://github.com/jakartaee/data/commit/3311aae747cc5584ec92bec48aa6b22b30766856)
- [x] [TCK tests for simple scenarios with composite ALL restriction](https://github.com/jakartaee/data/commit/6e32f4ca924a05d89fa86374eacbe2c3b43e1cab)
- [x] [TCK tests of unsatisfied and unmatchable restirction](https://github.com/jakartaee/data/commit/802aafa4e90767328308d5e7b91a461dabbc037d)
- [x] [TCK tests for simple scenarios with composite ANY restriction](https://github.com/jakartaee/data/commit/0a38c77341af35946984ab13b4c5aa8dc803f7f1)
- [x] [TCK tests for constraints via Is annotation, plus a test for Between constraint as a parameter type](https://github.com/jakartaee/data/commit/12753639dcef22775c7232dc773047efb6b56270)
- [x] [TCK tests for AtLeast, AtMost, GreaterThan, and LessThan constraints](https://github.com/jakartaee/data/commit/de5db5ebc34b4de99a148c02ac3caebc201fb217)
- [x] [TCK tests for EqualTo, NotEqualTo, In, and NotIn constraints](https://github.com/jakartaee/data/commit/45091f4725a52f83fe479d6c51fc2ab41619a38f)
- [x] TCK tests for the [Like constraint](https://github.com/jakartaee/data/commit/d01dbc7f18494170aa5269b3afd012b4d76fd1aa) and [NotLike constraint](https://github.com/jakartaee/data/commit/f25850639a1b014172278aee43477a42759b3479)
- [x] [TCK for the Null and NotNull constraints](https://github.com/jakartaee/data/commit/843001066a4afafaf5815593fe7735cf80d75cbe)
- [x] [TCK tests for append and prepend with Expression-typed argument](https://github.com/jakartaee/data/commit/ab6a4a7bf4d0c0249e9a21875ee42ebdb5cc8608)
- [x] [TCK tests for length expression](https://github.com/jakartaee/data/commit/847afbe591ae73385ac145ab28512c7fd23721d4)
- [x] [TCK tests for left and right expressions compared to a value](https://github.com/jakartaee/data/commit/7d931796a7f070a4d2e542d9671567f906669a6a)
- [x] [TCK tests comparing append, prepend, lower, and upper expressions to a value](https://github.com/jakartaee/data/commit/790b435ae19788b7b980a0cd2ec8096e56b36669)
- [x] [TCK test for NumericCast expression](https://github.com/jakartaee/data/commit/bbfaec6ed3b5c6ea489ada560f2331ad131848bf)

Start with the unchecked QueryOptions scenarios in this checklist, especially the Find, Delete, Query, and NativeQuery repository methods, and compare them with the completed entries and linked pull request #1567. Add the missing TCK coverage and mark each scenario complete once the relevant tests pass.

Written by the indexing model from the issue text.