How does __using__ actually work?

In short, this:

defmodule A do
  use Foo, opts
end

Is exactly the same as:

defmodule A do
  require Foo
  Foo.__using__(opts)
end

This is just sugar over it, see for yourself.