v0.2.6

• escape data in Rich tables so it treats the data as literal instead of trying to render it if it contains square brackets
• if a file name does not conform to DuckDB's rules on unquoted identifiers, wrap it in double quotes

v0.2.5

• Since DuckDB 0.10.0, read_csv is preferred to read_csv_auto, so filequery uses that for reading in CSVs now
• Improved CSV export from TUI. Filequery now uses a DuckDB copy statement behind the scenes to create the CSV instead of building the CSV from the contents of the result table in the UI

v0.2.4

• menu option to load a SQL file
  • brings up a file browser modal where a user can select a file to load into the current editor tab
• FileDb support for exporting query result to a JSON file as a list of JSON documents
• added dict_records property to QueryResult to allow users to retrieve the records as a list of dictionaries

v0.2.3

• Table list on the left pane is now a interactive tree that can be expanded to see columns and data types
• Added menu screen dialog
  • The "save SQL" and "save result" options are now buttons in the menu instead of key bindings, this helps reduce clutter in the UI
  • Menu has a button for exiting the program

v0.2.2

What's Changed

• added tabs in the TUI to allow for multiple SQL editors
• added keyboard controls in the TUI for switching between panes
• improved styles to make it easier to tell the currently active pane in the TUI

v0.2.1

What's Changed

• can now run filequery TUI without specifying files or a file directory, enabling users to to write their own SQL scripts for loading files with any options they want to specify
• use sample_size=-1 when reading csv, json and ndjson files so all records are sampled when DuckDB is determining the table structure
• in the TUI, the table list is now reactive, so creating/dropping tables causes the list to update
• dropping support for Python 3.7

v0.2.0

v0.2.0

• added TUI for querying files with a SQL editor in the terminal
• improved UX by adding short hand versions of all command line options (e.g. can now use -f instead of --filename)

v0.1.9

First GitHub release