search

multiprocessio / datastation

App to easily query, script, and visualize data from every database, file, and API.
https://datastation.multiprocess.io
Other
2.9k stars 112 forks source link

Table panel columns are not in the same order as its data source #271

Open pokle opened 2 years ago

pokle commented 2 years ago

I expect the table panel to show columns in the same order as its source. It appears to sort the columns alphabetically by default.

For example, if I query (sqlite): select 1 d, 2 c, 3 b, 4 a, the table panel displays these columns in the order a,b,c,d. I expect them to be in the same order as queried.

eatonphil commented 2 years ago

Yes column order from the response of queries is not stored at all right now so I just picked an order so it's not constantly changing.

You can modify the order today by editing the table details but yeah that's not too friendly.

This is a good feature request.