I have a drupal model called sheetnode([login to view URL]) and it uses socialcalc as a spreadsheet tool([login to view URL]).
I want to allow the sheets to query webservices or sql directly so users can use live data in their online spreadsheets. I'm not sure if its helpful but this functionality used to be available in the previous version of this socialcalc(written in javascript), but it was written in perl.