Attach `Diagnostic` to "duplicate table name" error

[eliaperantoni]

Is your feature request related to a problem or challenge?

For a query like:

SELECT * FROM users a, users a

The only message that the end user of an application built atop of DataFusion sees is:

Schema error: Schema contains duplicate qualified field name a.id

Similarly, for:

WITH cte AS (SELECT 1 AS col), cte AS (SELECT 2 AS col) SELECT 1

We get:

Error during planning: WITH query name "cte" specified more than once

We want to provide a richer message that references and highlights locations in the original SQL query, and contextualises and helps the user understand the error. In the end, it would be possible to display errors in a fashion akin to what was enabled by #13664 for some errors:

See #14429 for more information.

Describe the solution you'd like

Attach a well crafted Diagnostic to the DataFusionError, building on top of the foundations laid in #13664. See #14429 for more information.

Describe alternatives you've considered

No response

Additional context

No response

[alamb]

I think this is a good first issue as the need is clear and the tests in https://github.com/apache/datafusion/blob/85fbde2661bdb462fc498dc18f055c44f229604c/datafusion/sql/tests/cases/diagnostic.rs are well structured for extension.

[zjregee]

take

[eliaperantoni]

Hey @zjregee how is it going with this ticket :) Can I help with anything?

[zjregee]

Sorry for the delay, I will start and finish it in the next few days.