Add example of querying a database via pyodbc

[rdmolony]

Hey there, I saw this mentioned in beginner/extensions and extensions/creator. I'll try figure this out and put together a brief example that could be slotted into either section

[rdmolony]

Is it recommended to load from pyodbc to a file?

[kvnkho]

You would use pyodbc to query and load in memory, not a file if that is what you are asking.

[rdmolony]

It is yep! So for now larger than memory data won't be loadable this way? I'm trying to visualise DB -> Fugue -> BI tool

[kvnkho]

Definitely not. You would need to pre-aggregate in some way or query and persist part by part I think. Or you would use the database service itself to output that file.

[rdmolony]

great, thanks Kevin