based on metabase/metabase#6295 and my own experience trying to get Metabase to connect to a pgpool-managed Postgresql cluster, it seems like there is a problem with how Toucan builds SQL queries, which leads to the above error when such queries are executed against pgpool.
Maybe Toucan is trying to leverage a feature of Postgres that pgpool doesn't support?
Or perhaps Toucan is working correctly but Metabase is not implementing it right?