abdallah elhdad 7d3b4f9049 Add JSON type support for Oracle dialect ...

Added support for the :class:`_sqltypes.JSON` datatype when using the
Oracle database with the oracledb dialect.  JSON values are serialized and
deserialized using configurable strategies that accommodate Oracle's native
JSON type available as of Oracle 21c.  Pull request courtesy Abdallah
Alhadad.

This fix also includes new dialect-level indicators for JSON support;
some attention given to issue #13213 indicates we can close that issue.

Fixes: #10375
Closes: #13065
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13065
Pull-request-sha: 9a89237f4f

Change-Id: I8cbe35bc632dc9419642ddca8bf4ba9c20c0ae37

2026-04-03 14:53:53 -04:00

..

__init__.py

reorganized unit tests into subdirectories

2006-06-05 17:25:51 +00:00

test_case_statement.py

Fix type of CASE expressions which include NULLs

2024-01-15 12:08:10 -05:00

test_compare.py

add TString support

2025-11-30 14:38:13 -05:00

test_compiler.py

Coercion warning feedback for unary distinct outside aggregate function

2026-03-31 10:45:18 -04:00

test_computed.py

Try running pyupgrade on the code

2022-11-16 23:03:04 +01:00

test_constraints.py

Deprecate DropConstraint.isolate_from_table

2026-01-12 22:12:17 +01:00

test_cte.py

fix typos (#13038)

2025-12-18 21:18:42 +01:00

test_ddlemit.py

Add DDL association to Table, CreateView support

2025-11-08 13:42:15 -05:00

test_defaults.py

test oracle 23c, mariadb12; reduce backend use

2025-11-25 14:50:56 -05:00

test_delete.py

filter_by works across multiple entities

2025-12-04 13:53:27 +00:00

test_deprecations.py

test oracle 23c, mariadb12; reduce backend use

2025-11-25 14:50:56 -05:00

test_external_traversal.py

fix typos (#13038)

2025-12-18 21:18:42 +01:00

test_from_linter.py

test oracle 23c, mariadb12; reduce backend use

2025-11-25 14:50:56 -05:00

test_functions.py

update default driver for oracle, postgresql

2025-12-15 23:01:12 -05:00

test_identity_column.py

test oracle 23c, mariadb12; reduce backend use

2025-11-25 14:50:56 -05:00

test_insert_exec.py

allow batch with upsert if embed_values_counter is True

2026-02-05 10:09:09 -05:00

test_insert.py

fix typos (#13047)

2025-12-19 21:24:23 +01:00

test_inspect.py

Update black to v23.3.0 and flake8 to v6

2023-05-30 21:44:26 +02:00

test_labels.py

test oracle 23c, mariadb12; reduce backend use

2025-11-25 14:50:56 -05:00

test_lambdas.py

drop a 400 ton anvil on oracle 23c

2025-11-28 13:16:13 -05:00

test_lateral.py

Track a second from_linter for lateral subqueries

2021-02-05 13:54:37 -05:00

test_metadata.py

Mysql ddl compiler fall back to default index args

2026-02-23 13:21:47 -05:00

test_operators.py

Coercion warning feedback for unary distinct outside aggregate function

2026-03-31 10:45:18 -04:00

test_query.py

test oracle 23c, mariadb12; reduce backend use

2025-11-25 14:50:56 -05:00

test_quote.py

test oracle 23c, mariadb12; reduce backend use

2025-11-25 14:50:56 -05:00

test_resultset.py

Coercion warning feedback for unary distinct outside aggregate function

2026-03-31 10:45:18 -04:00

test_returning.py

update default driver for oracle, postgresql

2025-12-15 23:01:12 -05:00

test_roles.py

remove _implicit_subquery and all derived functions

2024-11-17 08:19:53 -05:00

test_select.py

filter_by works across multiple entities

2025-12-04 13:53:27 +00:00

test_selectable.py

Improve params implementation

2025-11-10 16:50:54 -05:00

test_sequences.py

test oracle 23c, mariadb12; reduce backend use

2025-11-25 14:50:56 -05:00

test_statement_params.py

add TString support

2025-11-30 14:38:13 -05:00

test_syntax_extensions.py

syntax extensions (patch 1)

2025-03-05 16:03:16 -05:00

test_table_via_select.py

Add DDL association to Table, CreateView support

2025-11-08 13:42:15 -05:00

test_tablesample.py

Update select usage to use the new 1.4 format

2020-09-08 17:13:48 -04:00

test_text.py

update default driver for oracle, postgresql

2025-12-15 23:01:12 -05:00

test_tstrings_py314.py

block json tests for non-json backends

2025-12-02 23:18:58 -05:00

test_type_expressions.py

Update black to v23.3.0 and flake8 to v6

2023-05-30 21:44:26 +02:00

test_typed_froms.py

Improve typing story for core from clauses.

2026-03-12 23:02:30 +01:00

test_types.py

Add JSON type support for Oracle dialect

2026-04-03 14:53:53 -04:00

test_update.py

filter_by works across multiple entities

2025-12-04 13:53:27 +00:00

test_utils.py

Add overload for ColumnCollection.get(col, default)

2024-05-04 11:33:23 +02:00

test_values.py

add recursive test to values cte

2025-07-15 22:52:05 +02:00