Describe the bug

When using Postgresql, R2dbc, and qualified table names, span names and table names are incorrect.

Steps to reproduce

query for SELECT * FROM "public"."person" where first_name = 'tom' with r2dbc.

Adding the following case to AbstractR2dbcStatementTest will reproduce:

Arguments.of(
    named(
        system.system + " Select from qualified Table",
            new Parameter(
                system.system,
                 "SELECT * FROM \"public\".\"person\" where first_name = 'tom'",
                 "SELECT * FROM \"public\".\"person\" where first_name = ?",
                // `"SELECT " + DB + "public.person"` would also be correct I think
                 "SELECT " + DB + ".person",
                 "person",
                 "SELECT")))

will yield:

[Span 1] Expected span to have name <SELECT tempdb.person> but was <SELECT tempdb.public>
Expected :SELECT tempdb.person
Actual   :SELECT tempdb.public

Expected behavior

the correct table name in the span.

The db.sql.table attribute is also incorrectly set to "public"

Actual behavior

"public" is parsed out as the table name.

Javaagent or library instrumentation version

9b97ac7 (main as of writing)

Environment

JDK: Java 23
OS: Ubuntu 24.04

Additional context

when using the Jooq library, this is the generated SQL. This syntax is illegal in other dialects.