[11.1.115 Pro] - ANOMALY: UPDATE formatting

[11.1.115 Pro] - ANOMALY: UPDATE formatting

I've got this formatting rule for UPDATE statements below:

	Code:
	UPDATE ... AS ... JOIN ... ON ... = ... AND ... OR ... SET ... = ... ,... WHERE ... = ... AND ... OR ... ORDER BY ... LIMIT ...;

Given is an UPDATE statement:

	Code:
	UPDATE `obu_cart_item` AS oci INNER JOIN `obu_group_of_sales_package` AS ogosp ON ogosp.`group_of_sales_package_tid` = oci.`group_of_sales_package_tid` SET `valid_from` = @a ,`valid_to` = @b ;

It gets formatted like this:

	Code:
	UPDATE `obu_cart_item` AS oci INNER JOIN `obu_group_of_sales_package` AS ogosp ON ogosp.`group_of_sales_package_tid` = oci.`group_of_sales_package_tid` SET `valid_from` = @a ,`valid_to` = @b;

Now, if I don't want this to auto-ruin my code, I have to add the INNER keyword to the UPDATE rule, and that will obviously make it no longer work for other types of joins (CROSS, LEFT/RIGHT OUTER). On the other hand, my formatting rule for SELECT statements similarly uses the lone keyword JOIN as an anchor and still does recognize INNER/etc as something that should go hand in hand with JOIN.

Maybe you can break the long UPDATE rule into multiple smaller rules and let the engine pickup the correct JOIN formatting based on the type of JOIN?

1. UPDATE UPDATE ... AS ...
2. CROSS JOIN ... ON ... = ... AND ... OR ...
3. LEFT JOIN ... ON ... = ... AND ... OR ...
4. RIGHT JOIN ... ON ... = ... AND ... OR ...
5. OUTER JOIN ... ON ... = ... AND ... OR ...
6. FULL JOIN ... ON ... = ... AND ... OR ...
7. SET ... = ...
,...
WHERE ... = ... AND ... OR ...
ORDER BY ...
LIMIT ...;

That may solve the UPDATE formatting, but you may need to review and modify all other rules because the new bunch of JOIN rules clashing with your other rules.

This is definitely a good idea, as it would offer greater control over what and how to format. However, since I use multiple RDBMSs and have multiple formatting rules for each, I always refrain from doing that due to the lack of easy migration/synchronization of the changes made to rules.

Would you consider my feature request posted here? I ask there for formatting rules, but that might come in handy for snippets too.