Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Formatter] Readable MySql View Source #23468

Open
filippo-pequini opened this issue Apr 18, 2024 · 1 comment
Open

[Formatter] Readable MySql View Source #23468

filippo-pequini opened this issue Apr 18, 2024 · 1 comment
Assignees
Labels
feature request xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc.

Comments

@filippo-pequini
Copy link

Is your feature request related to a problem? Please describe.
All the time i need to visualize the Source query of a view in mysql the view comes with lots of { } that makes read the source code almost impossibe and i need to spend a large ammount of time removing it to start working on the query
example:
SELECT
*
FROM
(((table1 t1
JOIN table2 t2 ON
(((t1.id = t2.id))))
JOIN table3 t3 ON
(((t3.id = t2.id))))
JOIN table4 t4 ON
((t4.id = t3.id)));

Describe the solution you'd like
I would like the source code to come in a more friendly way such as the example bellow:
SELECT
*
FROM table1 tl
JOIN table2 t2 ON t1.id = t2.id
JOIN table3 t3 ON t3.id = t2.id
JOIN table4 t4 ON t4.id = t3.id
;

@E1izabeth E1izabeth added xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc. and removed wait for review labels Apr 18, 2024
@E1izabeth E1izabeth self-assigned this Apr 18, 2024
@E1izabeth
Copy link
Member

Thank you for request

@E1izabeth E1izabeth changed the title Readable MySql View Source [Formatter] Readable MySql View Source Apr 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc.
Projects
None yet
Development

No branches or pull requests

2 participants