[Bug] Results table does not open when using Postgres

[svenvg93]

Describe the bug
It seems that introduction of #2015 does not play nice with postgress.
When opening the results table page a SQL error is shown

SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...ere "data" is not null and "status" = $1 order by "data"->'s... ^ (Connection: pgsql, SQL: select distinct * from "results" where "data" is not null and "status" = completed order by "data"->'server'->>'name' asc)

I tried an instance running SQLite, there is works as intended.

To Reproduce
Steps to reproduce the behavior:

1. Use postgress 17.2 as an database
2. Run v1.2.1
3. Open the result page

Expected behavior
Result page opens normally.

Environment (please complete the following information):

• OS: Raspberry Pi OS
• Architecture: ARM64
• Browser Safari
• Version 1.2.1

Screenshots

Logs
`Nothing is shown in the docker logs or laravel logs.

[comassky]

Same issue

[alexjustesen]

@svenvg93 if you get to it before I do, we should be able to change the query builder to select the field and order by it...

Result::query()
    ->select('data->server->name AS server_name')
    // ....

You should be able to use the IP Address filter as a reference.