Question) In MariaDB/MySQL 'View', how to see & edit SQL by only what I enter? not formatted.

[mic-user]

Hi.

If open a VIEW of Maria/Mysql,
now I can see the SQL that automatically formatted(?) by the system that like ' select db.col from db' way.
But I really WANT that always see and edit what I have entered like 'select * from db_name'. Not formatted.
(Mean that, want to load 'raw source what user literally enter' not the 'auto-formatted query' from the db file format '.frm' of view.)

Is there an option to switch mode?

[LonwoLonwo]

Hello @Mitchell-kw-Lee

DBeaver uses the SHOW CREATE VIEW statement for the views definitions reading.
Basically, only simple formatting for line delimiters and tabulation is used.

[mic-user]

@LonwoLonwo

Erm,

in case of maria/MySQL,
there is query finds in the DB folder like 'View name.frm' and
it contain below contents that

---

TYPE=VIEW
query= !!! HERE regulated/formatted Query by...possibly MariaDB !!!'
md5=6806b9bc44d6be06b50b108dbf7c9eca
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-02-04 01:10:43
create-version=2
source= !!! here my input/user wrote !!!
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8= !!! Same as first line the 'query' !!!
mariadb-version=100605

---

So...My wish is that
DBeaver could have capability to load and save the 'source' on the editor.
not the..system formatted not human readable string..

Can we have the option?