[FEATURE] Quick Table Search (Ctrl + P) with Preview

[sahithvibudhi]

Description:
Add the ability to quickly search and open tables using a keyboard shortcut (Ctrl + P or Cmd + P on macOS).

Proposed Behavior:

• Pressing Ctrl + P opens a quick search palette (similar to VSCode).
• Users can type partial table names to filter results.
• Selecting a table shows:
  -- A preview of the top N rows.

Why:

• Faster navigation in large databases with many tables.
• Saves time compared to manually browsing schemas.
• Familiar UX for developers who use editors like VSCode.

Acceptance Criteria:

• Keyboard shortcut (Ctrl/Cmd + P) opens the search palette.
• Tables filter as user types.
• Pressing Enter on a result opens a spreadsheet-like view of top N rows.
• use debounce for search and useMemo(for table names) for performance

[mushroomgenie]

@sahithvibudhi I am working on this. I had a question, where do we display the preview of the rows, do we create a new tab in the query workspace ?

[sahithvibudhi]

@mushroomgenie assigned. try cmd + p in vscode. we need something similar.

beekeeper is a good example to try. It has a similar feature

[mushroomgenie]

@sahithvibudhi In vscode the file just opens in a new tab, in the case of DataPup it would be a new query tab right ?