Line /row number option for table vizualisation

[nicocashie]

In a table chart / visualization, the only way to display line / row number is to write a native SQL query and compute the line / row number with the function proposed by the database.

Could be usefull sometimes to be able to display the line / row number.
So it could be an option for table chart / vizualisation.
This is by default in a standard SQL browser / explorer (like Toad, SQL Server Management, dbeaver).

⬇️ Please click the 👍 reaction instead of leaving a +1 or update? comment

[jschuur]

One comment on why the workaround of calculating this in SQL (via ROW_NUMBER e.g.) isn't always ideal: When you yo have multiple columns and sort by them in a table visualisation, this doesn't re-run the query and your line # value would still be based on the original sort order from the SQL query.

In my use case, I'd like to see the actual line number of the current row, irrespective of any sorting.