Files
Andrew Khoma 4dee5a8d5e Merged PR 1553896: [Gateway][SinglePool] Implement rest of DMLs and explains
### Does this PR have any customer impact?
yes

### Type (Feature, Refactoring, Bugfix, DevOps, Testing, Perf, etc)
feature

### Does it involve schema level changes? (Table, Column, Index, UDF, etc level changes)
yes, creating new UDFs:
- `mongo_api_internal.run_explain_as_user`
- `list_databases`

### Are you introducing any new config? If yes, do you have tests with and without them being set?
yes, gating the explain experience behind the `pgmongo.enableExplainsInSharedUserPool`

### Release Note (Refer [Template](../docs/release_notes/pgmongo_template.md))

### Description
Port the rest of the DML commands and explains to the backend.
Update all of the test coverage for explains for the new changes too.
Move ListDatabases command from Gateway to backend

Related work items: #3759098
2025-02-19 17:00:35 +08:00

6 lines
232 B
SQL

CREATE OR REPLACE FUNCTION __API_SCHEMA_V2__.list_databases(
p_list_databases_spec __CORE_SCHEMA__.bson)
RETURNS __CORE_SCHEMA__.bson
LANGUAGE c
IMMUTABLE PARALLEL SAFE STRICT
AS 'MODULE_PATHNAME', $$command_list_databases$$;