sql: syntax error in schema expressions that with BETWEEN comparison of string and collated string

In v24.3.0, and in some patch between v24.2.4 and v24.2.10, and v24.1.5 and v24.1.8, we began allowing comparisons between strings and collated strings:

```sql
SELECT '' COLLATE "de_DE" BETWEEN '' AND '';
-- ?column?
-- ------------
-- t
-- (1 row)
```

However, using the same example expression in a schema expression, like a default column value, is a syntax error:

```sql
CREATE TABLE t (
c BOOL DEFAULT ('' COLLATE "de_DE" BETWEEN '' AND '')
);
-- ERROR: relation "t" (104): at or near "collate": syntax error
-- SQLSTATE: 42601
-- DETAIL: source SQL:
-- SET ROW ('':::STRING COLLATE de_DE BETWEEN '' COLLATE de_DE AND '' COLLATE de_DE)
-- ^
```

Jira issue: CRDB-47922