Motivation

• The SDK TablesClient.search_rows() accepted either a raw list or a paginated dict containing items, and raised ValueError("Unexpected search response") for other dict shapes; some deployments still return paginated payloads keyed as rows, causing executor failures when calling tracecat_registry.core.table.search_rows.

Description

• Updated packages/tracecat-registry/tracecat_registry/sdk/tables.py::TablesClient.search_rows to accept the canonical items paginated payload and to normalize legacy rows-based paginated payloads into a types.TableSearchResponse shape while preserving existing validation.
• Normalization maps rows -> items and forwards next_cursor, prev_cursor, has_more, has_previous, and optional total_estimate into the returned response.
• Added unit tests in tests/registry/test_tables_sdk.py that verify normalization of the legacy rows payload and that unexpected dict shapes still raise ValueError("Unexpected search response").

Testing

• Ran uv run ruff check packages/tracecat-registry/tracecat_registry/sdk/tables.py tests/registry/test_tables_sdk.py which passed.
• Attempted uv run pytest tests/registry/test_tables_sdk.py tests/registry/test_core_table.py -q, but the run failed in this environment due to missing PostgreSQL on localhost:5432 required by test fixtures, preventing a full test run here.
• The change is covered by the new SDK-focused tests and will be verified in CI where the full test environment (including the database) is available.

Codex Task

Summary by cubic

Normalize legacy table search responses in TablesClient.search_rows to support old "rows" pagination alongside "items". This prevents executor errors on deployments that still return "rows".

• Bug Fixes
  • Map rows -> items and forward next_cursor, prev_cursor, has_more, has_previous, and optional total_estimate into TableSearchResponse.
  • Keep strict validation; unexpected dict shapes still raise ValueError("Unexpected search response").
  • Add unit tests with typing-safe assertions to cover normalization and the rejection path.

^{Written for commit 95d899c. Summary will update on new commits.}