CREATE TABLE dvt_test.tab_json
(
  id VARCHAR2(10) NOT NULL PRIMARY KEY
, col_json1 CLOB
, col_json2 CLOB
);
ALTER TABLE dvt_test.tab_json ADD CONSTRAINT tab_json_chk1 CHECK (col_json1 IS JSON) ENABLE;
ALTER TABLE dvt_test.tab_json ADD CONSTRAINT tab_json_chk2 CHECK (col_json2 IS JSON) ENABLE;
INSERT INTO dvt_test.tab_json VALUES (1,'{"a": 1}','{"a": 1}');
COMMIT;

CREATE TABLE dvt_test.tab_json
(
  id varchar(10) NOT NULL PRIMARY KEY
, col_json1 json
, col_json2 jsonb
);
INSERT INTO dvt_test.tab_json VALUES (1,'{"a": 1}','{"a": 1}');

$ data-validation validate column -sc ora_local -tc pg_local -tbls="dvt_test.tab_json" --count '*' --sum '*' --min '*' --max '*' --avg '*' --std '*' --filter-status fail
...
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) function length(json) does not exist
LINE 2: ..._json2 AS col_json2, length(t1.id) AS length__id, length(t1....
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

$ data-validation validate row -sc ora_local -tc pg_local -tbls="dvt_test.tab_json" -pk=id --hash=col_json1,col_json2
...
  File "/usr/local/google/home/neiljohnson/github/professional-services-data-validator/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
cx_Oracle.DatabaseError: ORA-00932: inconsistent datatypes: expected CLOB got CHAR