DBeaver has an Excel-ish interface for SQL. The usual rows and columns layout, you can double click a cell to edit it.
You do have to Save to flush the changes to the DB though, and the errors when queries are wrong or whatever are hard to read. Your users will likely be totally unable to grok the errors. I work in IT and it's somewhat difficult for me because of the chain of error handlers (SQL -> Java error type -> Java error -> display to user; there's a lot of Java stuff mixed into your SQL errors).
p_plno|1 year ago
everforward|1 year ago
You do have to Save to flush the changes to the DB though, and the errors when queries are wrong or whatever are hard to read. Your users will likely be totally unable to grok the errors. I work in IT and it's somewhat difficult for me because of the chain of error handlers (SQL -> Java error type -> Java error -> display to user; there's a lot of Java stuff mixed into your SQL errors).
namaria|1 year ago