Issue 1:
Getting an error when trying to duplicate a virtual dataset (feature in this PR: #20309)

How to reproduce the bug

Visit the Datasets page

On the Actions column of a Virtual dataset, click the duplicate icon

Enter a dataset name and click "Duplicate"

Expected results

Virtual dataset gets copied and created successfully

Actual results

An error message appears and the dataset doesn't get created

Screenshots

Environment

(please complete the following information):

browser type and version:

superset version: master

python version: python --version

node.js version: node -v

any feature flags active:

Checklist

Make sure to follow these steps before submitting your issue - thank you!

I have checked the superset logs for python stacktraces and included it here as text if there are any.

I have reproduced the issue with at least the latest released version of superset.

I have checked the issue tracker for the same issue and I haven't found one similar.

Issue 2:
A clear and concise description of what the bug is.

How to reproduce the bug

Setup a postgres table with a timestamp with time zone (timstamptz) column

Query that column using sql editor or consume that column in a chart

See error

Expected results

Be able to see the column

Actual results

superset_1 | Traceback (most recent call last):
superset_1 | File "/app/superset/views/base.py", line 211, in wraps
superset_1 | return f(self, *args, **kwargs)
superset_1 | File "/app/superset/utils/log.py", line 245, in wrapper
superset_1 | value = f(*args, **kwargs)
superset_1 | File "/app/superset/views/core.py", line 2574, in sql_json
superset_1 | command_result: CommandResult = command.run()
superset_1 | File "/app/superset/sqllab/command.py", line 104, in run
superset_1 | raise ex
superset_1 | File "/app/superset/sqllab/command.py", line 96, in run
superset_1 | status = self._run_sql_json_exec_from_scratch()
superset_1 | File "/app/superset/sqllab/command.py", line 138, in _run_sql_json_exec_from_scratch
superset_1 | raise ex
superset_1 | File "/app/superset/sqllab/command.py", line 133, in _run_sql_json_exec_from_scratch
superset_1 | return self._sql_json_executor.execute(
superset_1 | File "/app/superset/sqllab/sql_json_executer.py", line 111, in execute
superset_1 | raise SupersetErrorsException(
superset_1 | superset.exceptions.SupersetErrorsException: [SupersetError(message="'+00'", error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'PostgreSQL', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})]

Screenshots

Environment

(please complete the following information):

browser type and version: Chrome 102

superset version: 1.5.1

python version: 3.8

node.js version: none

any feature flags active:

Checklist

Make sure to follow these steps before submitting your issue - thank you!

I have checked the superset logs for python stacktraces and included it here as text if there are any.

I have reproduced the issue with at least the latest released version of superset.

I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

This was not an issue in the 1.4.2.

May be similar to #19995