feat: support generating tables or datasets natively in the backends given a schema

[kszucs]

Is your feature request related to a problem?

No response

Describe the solution you'd like

I think we should add a new operation for generating random tables because backends may have native support for it, like clickhouse has both a table engine and a function for this:

• https://clickhouse.com/docs/en/engines/table-engines/special/generate
• https://clickhouse.com/docs/en/sql-reference/table-functions/generate

What version of ibis are you running?

main

What backend(s) are you using, if any?

No response

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[gforsyth]

We should also support this for backends without a native generation method using something like Faker.