Enhance data explorer

[loicknuchel]

Currently Azimutt has very great schema exploration features but is quite limited for data exploration.

What is already available for sources connected to a database:

• for tables
  • view a sample value for each column (random not null)
  • default query with a SELECT * to quickly explore values
• for columns
  • view top 5 most used values with count, cardinality and % of nulls
  • default query with a count of used values in the column
• a SQL editor to run any query

What we want to add:

• Keep result set history to browse past results
• View a result row in modal to view it more easily (especially for JSON fields)
• Add a right pane to explore linked rows (foreign keys), make it stackable to navigate several times
• On simple table SELECT, add columns with counts for tables linking to result rows and a quick way to view them
• Allow to search in data (extend the search bar with ability to look inside the database to fetch rows matching the query)
• Make column statistics available in modal from result set header