Semicolon Line Terminator When Formatting?

I recently installed SQL Assistant into SSMS to test it out as an alternative to the current solution my company uses for SQL code formatting. I like the customizability of the formatting options, but I can't seem to figure out how to make it automatically insert semicolons at the end of each SQL statement. This is something that is required by my company's standards, so naturally, I looked for that option when testing out the formatting functionality. I tried messing with the formatting rules, too, and adding a semicolon in the rule doesn't seem to apply to the code when formatting. I did notice in the documentation for customizing the formatting rules that extra keywords are ignored if they do not affect the code being formatted. I wonder if the semicolon I've added is also being ignored.. Is there something I am missing for how to enable automatically including semicolon line terminators?

Thank you in advance!

Adding semicolons isn't a feature supported by code formatting/beautification. I can't think of any tool in the entire SQL Assistant toolset that could do that.

That's too bad.. Thanks for the response!

If your code has SQL statements separated by consecutive line breaks, or you use the code formatting tool first to add them where statement separation lines are missing, then perhaps you can use a simple regex based text search and replace in the next step to add semicolons, replacing consecutive line breaks with a semicolon followed by line breaks.

Hmm... Interesting approach. I guess it would be possible to create a macro that first applies a set of formatting rules that makes every statement single-line, then use an advanced text processing rule to replace linebreaks with a semicolon + linebreak pair, and then apply another formatting rule that is more visually appealing.

My only with that is that there are some statements/keywords/whatever for which I simply cannot beat SA into submission and it always ruins the code. One such misfortune group is the UPDATE statement with multiple tables and when having a CROSS APPLY somewhere. But there are a few more. For this reason, I gave up formatting the context of the entire editor and now I only apply formatting to selected parts of the code.