feat(duckdb): add read_gsheets()

[NickCrews]

Is your feature request related to a problem?

I often read/write data to google sheets in my duckdb workflows. There is a duckdb community extension that support this. IDK what our stance is on community extensions: do we only want to include methods on the duckdb Backend class for official extensions?

If you think this is a good addition, I can submit a PR :)

What is the motivation behind your request?

making it easier for ibis users to read/write google sheets.

Describe the solution you'd like

I think it should be pretty similar to the existing read_* functions. The tricky thing would be who should own the google sheet that we use for testing. Probably a simple sheet like this that is public, owned by the ibis org would be great. But probably also not a big deal if some personal account holds it, it wouldn't be that hard to switch later. Let me know what you would want to do here.

What version of ibis are you running?

main

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

duckdb. I doubt this is supported by any other backend.

Code of Conduct

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

[cpcloud]

I think this would be nice to have. I've got a couple personal use cases in mind too :)

[cpcloud]

We don't really have a stance per se on the relationship between backend read_* methods and whether an extension is community or core. It's more driven by developer/user motivation and perceived utility (which hopefully ultimately corresponds to actual utility!).

[lostmygithubaccount]

I would also use this!

[NickCrews]

I think I want to add a to_gsheet method as well. I think that is gonna require a Google service account. @cpcloud do you have an existing service key or know how to make one? Seems like the ibis org should have more control over that then if I made it, but I can if you want!