Yes, starting from 0.6.0 (
Ultimate SEO URL), phpBB SEO is using the exact same code as released, with only a slight change for cross domain usage (with the downloads sub domain, for the zero dupe).
Before that, the code used here was very similar but already used some SQL rewriting.
++