This plugin adds a quick fix to your ADT environment for formatting an ABAP SQL statement. You can customize it in the preferences:
- Align operators
- Standardize operators (e.g., convert all 'EQ' to '=')
- Add spaces to each line
- Additional spaces in condition lines
- Order of keywords (please use it wisely)
- Combine SELECT with FROM/INTO until a certain character limit
- Combine FROM with JOINs until a certain character limit
Still in Beta. If you encounter any bugs, feel free to report them.
Please note that it's disabled in some cases. These will be implemented in the future.
Planned for Version 1:
- Convert SQL statement to new syntax
- Add escaping to host variables
- Add commas between fields
- CASE/WHEN syntax
- SELECT in WHERE
Categories: Application Development Frameworks, Code Management, Database, Editor
Additional Details
Eclipse Versions: 2023-12 (4.30), 2023-09 (4.29), 2023-06 (4.28), 2023-03 (4.27), 2022-12 (4.26), 2022-09 (4.25), 2022-06 (4.24), 2022-03 (4.23), 2024-03 (4.31), 2024-06 (4.32), 2024-06 (4.33)
Platform Support: Windows
Development Status: Beta
Date Created: Tuesday, October 10, 2023 - 15:05
License: Apache 2.0
Date Updated: Friday, December 15, 2023 - 11:25
Submitted by: Lukas Bachmann
Date | Ranking | Installs | Clickthroughs |
---|---|---|---|
September 2024 | 248/547 | 12 | 1 |
August 2024 | 311/641 | 27 | 14 |
July 2024 | 296/663 | 35 | 16 |
June 2024 | 303/681 | 39 | 15 |
May 2024 | 300/682 | 41 | 19 |
April 2024 | 306/687 | 40 | 14 |
March 2024 | 305/694 | 47 | 9 |
February 2024 | 289/687 | 45 | 10 |
January 2024 | 333/691 | 34 | 14 |
December 2023 | 261/671 | 60 | 15 |
November 2023 | 295/686 | 55 | 16 |
October 2023 | 376/673 | 25 | 28 |
Reviews Add new review
Good tool for messy SQL writers loke me
Submitted by Frank Berwanger on Fri, 06/21/2024 - 09:16
Thanks for this nice tool.
I regularly have an issue with up to n rows. Your quick fix puts it somewhere before the into-clause. But it should be behind it.
the left jion format
Submitted by Jia Pengsan on Fri, 11/10/2023 - 01:41
when use left join, the left join is incorrect
and could you add a choice don't store comments,
I thought it is necessary to use comments in SQL statements.
thanks
Hi, I know this bug. I fixed…
Submitted by Lukas Bachmann on Fri, 11/10/2023 - 13:38
In reply to the left jion format by Jia Pengsan
Hi, I know this bug. I fixed it already yesterday, so please update the plugin. And there is the option to delete the comments... but be careful with that setting :)