Superset - Provide a way to disable upsert for query

Sometimes we want to get the history of a timeseries from a pinot table which is enabled for upsert.

There doesn't seem to be anyway to toggle option(skipUpsert=true) in superset or ability to modify generated pinot queries.

Looking for a way to configure a new data source connection with upsert disabled ideally through a new option passed in the connection string with the sqlalchemy driver provided with superset[pinot].

Start by tracing how Superset's Pinot SQLAlchemy connection options are passed into generated Pinot queries, focusing on the connection string and query-generation paths mentioned in the issue. Done means a data source can disable upsert handling so queries include the requested skipUpsert=true behavior, with coverage for the new option.

Written by the indexing model from the issue text.