How would you go about loading sql Data into a dataframe? Is there some solution for this? (edit: removed unnecessary secondary question)

Good question. I'm also curious about that.

I just found that the kotlin jupyter notebooks apparently support exposed. I had some trouble with that but maybe if I use %use exposed it might work. https://github.com/Kotlin/kotlin-jupyter

For DataFrame we have this issue, but currently no ETA when it gonna be implemented. As for

exposed

, it nicely work with Kotlin Notebook, but I plan to improve the integration in future, to generate DSL on the fly, when the connection created.

Tables-kt (https://github.com/SciProgCentre/tables-kt), which is another vision of how table library could look like has integrations with both exposed and dataframe. One could use them for inspiration to make direct connection. I think tables-kt still makes sense as an integration layer API.