Support retrieving hidden columns during inspection

[edgarrmondragon]

For ELT applications extracting data from CockroachDB, it'd be good to get the rowid column during inspection for tables that don't declare an explicit primary key.

The current behavior of the dialect for CockroachDB>=19.1 is to filter the column out with WHERE ... AND NOT is_hidden::bool.

Perhaps popping a boolean argument include_hidden from kw in CockroachDBDialect.get_columns(self, conn, table_name, schema=None, **kw) could be used to decide if hidden columns are to be inspected.

[kernfeld-cockroach]

@gordthompson do you think this would be a useful feature for SQLAlchemy users? If it looks useful, could you work on this when you have some free time?

[gordthompson]

Hi, Paul. Sure, I can take a look at implementing this.

[edgarrmondragon]

Thank you @gordthompson !