bdash-app/bdash

[feature request] Execute multiple statements

eagletmt opened this issue · 0 comments

Currently, Bdash executes one statement at the cursor position. It would be great if Bdash executes multiple statements with the same connection.
This feature request is similar to #14 but not limited to MySQL variables.

Use case

I'd like to set session variables to execute query. A simple example is setting timezone in the current session.

set timezone to 'Asia/Tokyo';
show timezone;

Another example is SUPER data type in Redshift. It requires set enable_case_sensitive_identifier to true to refer mixed case fields.
https://docs.aws.amazon.com/redshift/latest/dg/super-configurations.html

SET enable_case_sensitive_identifier to TRUE;

SELECT json_table.data."ITEMS"."Name",
       json_table.data."price"
FROM
  (SELECT json_parse('{"ITEMS":{"Name":"TV"}, "price": 345}') AS data) AS json_table;

Bdash doesn't display ITEMS.Name field for now.