FWIW I am in middle to a big refactor for the project (mostly due to the evolution of jupyterlab's plugin tooling), I can look into how to integrate sqlfluff nicely here after that.

Without the the refactor, the development envrionment for this plugin is just nightmare-ish to use, so that is currently trumping all tasks.

Hello 👋 I am back with some updates.

I have completed my refactor and have some time to work on this project.

I assume you are working on sqlfluff base on this link on adding custom formatter?

A stop gap solution would be copy and paste handle_line_ending_and_magic logic and any assoicated variables needed in your custom formatter, and don't ignore the sql related magics.

I am just a bit hesitant about turning blacklist into whitelist, as I don't fully comprehend how that helps/fits in in the grand scheme of things.

With that said, I would love to add sqlfluff support, would you mind sharing what you have got if you actually implemented it 🙏

Hi Ryan, I haven't hacked anything yet. I decided to go forward without this for this year's edition (of the db course).

PS: I used jupyter-lsp and sql-language-server instead but I think having the Format button would be much better to reduce variability in students code :-)

Hi @flaviomartins - could you perhaps attach a notebook from your course here please?

Such that I can confirm it works for your usecase from the get go :)

Hi @ryantam626, ok, I think this notebook could be our MWE

Lab02.ipynb.zip

sweet! thanks, i will see what i can do, but my bandwidth is more limited these days so i will be a bit slow.