The SQL formatter (Editor>Format Code) will not work whenever the SQL has the below special characters required for defining data type. Trust me, I don't like that option but there's a ton of SQL views we have that uses it. This is for a SingleStore DB which uses mySQL. Here is an example of how it's used.
COALESCE(FIELD_NAME,0):>bigint(20) NULL) AS NEW_FIELD_NAME
My current option is to find all instances, insert line breaks around that portion of SQL, comment it out and then format the whole thing and go back and remove my comments.
Is there any way around this?