If my reading of the SQL standards and database specific documentation is incorrect, each backend that has special rules can simply override _create_constraint_name and apply whatever extra rules it needs without adding another database feature property.