@
Chandrak- I find this program ==>>
DB Browser for SQLite useful to interrogate the on-disk database. It can export to a CSV, which can be read, sorted, and rearranged in this program ==>>
CSVFileView or of course a spreadsheet such as Excel, Calc or Sheets. You wont see columns created from other columns in the on-disk database.
You can easily break the on-disk database with SQLiteBrowser, so it's best to copy the metadata.db file elsewhere and open it there.
Here's the list of authors in my test library as a CSV created with SQLite Browser and viewed with CSVFileView.
SQLite Browser and CSVFileView are both free to use
BR