[pgadmin-org/pgadmin4] f7045b: Fixed an issue where format sql was messing up ope...

Branch: refs/heads/master
Home: https://github.com/pgadmin-org/pgadmin4
Commit: f7045b58d4d1b98b6a2f035267d2dd01c7235aa6
https://github.com/pgadmin-org/pgadmin4/commit/f7045b58d4d1b98b6a2f035267d2dd01c7235aa6
Author: Pravesh Sharma <pravesh(dot)sharma(at)enterprisedb(dot)com>
Date: 2024-02-02 (Fri, 02 Feb 2024)

Changed paths:
M docs/en_US/images/preferences_sql_formatting.png
M docs/en_US/preferences.rst
M web/package.json
M web/pgadmin/misc/__init__.py
R web/pgadmin/misc/sql/__init__.py
M web/pgadmin/tools/sqleditor/static/js/components/sections/Query.jsx
M web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py
M web/yarn.lock

Log Message:
-----------
Fixed an issue where format sql was messing up operator. #5083

- The formatting is done on client side now using sql-formattor JS lib. Backend API based formatting is removed.
- Added new options data type case, expression width, function case, lines between queries, logical operator new line and new line before semicolon available in the new lib.
- Removed old options comma-first notations, re-indent aligned, re-indent, strip comments and wrap after N characters as not available in the new library.
- Capitalise casing is replaced with Preserve casing as it is not supported by the new library.
- Also fixes #6785, #6990, #7115.