Console: Run SQL HTML results are now div instead of table; can't copy/paste into spreadsheet editor anymore

[carlpaten]

Version Information

Server Version: v2.4.0
CLI Version (for CLI related issue): v2.4.0

Environment

OSS

What is the current behaviour?

When using the Run SQL page, tabular results are returned as a series of nested divs, which cannot be pasted into a spreadsheet editor without losing the table structure

What is the expected behaviour?

As in Hasura 1.x, the Run SQL page should show tabular results using HTML <table>

How to reproduce the issue?

1. Visit /console/data/sql
2. SELECT some multi-row, multi-column dataset
3. Inspect results; view that the table is made of <div>s
4. Try to paste into Google Sheets and see that it doesn't work

Keywords

hasura web console run sql html table div copy paste google sheets microsoft excel

[ajohnson1200]

@carlpaten super easy workaround: click Export Data --> Export Data CSV and then pipe that into Google Sheets?

[carlpaten]

Export Data CSV seems to be broken, I can never get more than a small number of records. Also, copying from results used to allow a quick and easy way to extract ad-hoc data sets; Export Data CSV, even if it worked, would require the extra steps of creating a view and then dropping it afterwards. I'm not a big fan!

[robertjdominguez]

Converting this to a discussion as you all talk through @ajohnson1200's suggestion 👍

[carlpaten]

@robertjdominguez this is definitely a bug report/feature request (the line can be blurry sometimes) rather than a request for assistance.

[dsandip]

@carlpaten 💯 agreed. Will move it back to an issue and also follow up on the Export CSV workflow being broken. cc: @meetzaveri

[dsandip]

@carlpaten Also, sorry about ping-pong-ing this :)

[carlpaten]

No worries, thank you so much for your attention.

[meetzaveri]

As suggested by @dsandip , I am creating issue from this discussion and will lock this discussion