SPACE-GE-% causes PostgreSQL error "column does not exist" in SpaceMapper.php

[binch31]

Description:
Bug description:
When using Workspace 4.2.0 with PostgreSQL, the workspace list fails to load with the error:
SQLSTATE[42703]: Undefined column: ERROR: column "SPACE-GE-%" does not exist
Environment:

Workspace version: 4.2.0
Nextcloud version: 31.0.12
Database: PostgreSQL
PHP version: 8.x

Root cause:
In lib/Db/SpaceMapper.php (lines 102 and 213), the LIKE condition uses double quotes around the string value:

'gu.gid like "SPACE-GE-%"'

PostgreSQL interprets double quotes as column/table identifiers, not string literals. This works on MySQL but fails on PostgreSQL.
Fix applied:
Replace both occurrences with a proper parameterized query:

$qb->expr()->like('gu.gid', $qb->createNamedParameter('SPACE-GE-%'))

[zulf10]

Same issue here.

Environment:

Workspace version: 4.2.0
Nextcloud version: 31.0.12
Database: PostgreSQL
PHP version: 8.x

To reproduce :

• Create new workspace (or use already one)
• add user to workspace and attribute into WorkSpaceManager group
• connect with user dans go to workspace app.
• A network error message appears

[jhaan79]

Same here.

Workspace version: 4.3.0
Nextcloud version: 32.0.5
Database: PostgreSQL 16
PHP Version: 8.3.30

Reproduce:

• Create workspace
• Add user as WA
• Open workspace as that user
• Workspace error
• See nextcloud.log