support for all join types supported by SQL::Abstract::More

[Sergiy Zuban]

Hi Laurent,

I was trying to use right outer joins and noticed they are not supported by DBIx::DM, but SQL::Abstract::More supports them.

I see todo comment in DBIx::DataModel::Meta::Schema::_parse_join_path that you were going to add support for all join types.

I've tried to adjust regexp to allow <= connector and everything seems to work as I expected, but I'm not 100% sure it works correctly with all options (since there is a special logic controlled by sql_no_inner_after_left_join option probably sql_no_inner_before_right_join will be useful for someone). Also I'm not sure if "multiplicity" checks you have for left joins are still valid for right joins.

Please let me know what you think about all this.

Thank you.

PS.

Also I was trying to get join syntax specification as $schema->sql_abstract->{join_syntax}, but figure out that DBIx::DataModel::Meta::Schema nothing knows about DBIx::DataModel::Schema, thus hardcoded list/regexp of supported join connectors is the only working solution.