Add page on Postgres-compatibility

[szarnyasg]

The documentation should state:

1. that we strive to be compatible with Postgres
2. the cases where DuckDB's behavior differs from Posgres'

Differences:

• [ ] Implicit casting in UNION https://github.com/duckdb/duckdb/issues/11958