updated several specs and factories to accomodate new permissions

This adds Keyset pagination to GraphQL lists. PoC for that is
pipelines on merge requests and projects.

When paginating a list, the base-64 encoded id of the ordering
field (in most cases the primary key) can be passed in the `before` or
`after` GraphQL argument.

To find the pipeline for a specific sha requires scanning the list of
all pipelines for a ref that contains the sha. This makes it hard to
find the pipeline id needed to access a trace for a specific job run
in the pipeline using the API.

The spec was trying to sort pipelines by user ID, but the same user ID
was being used for each pipeline in the spec. This is similar to #33001.

Allow only indexed columns in #order_and_sort. Remove present (Because unnecessary) from condition. Added spec just in case.

- Fix inappropriate evaluation(casecmp) to regex
- Fix missed boolean conversion
- Improve spec

Fix broken test