So do people just use SQL databases in the wild?
I’m not sure what you are asking here. It should be reasonably easy to get a SQL database into a table, especially given that with IterableTables you can convert anything into anything, I don’t think you’ll need to manually push one row at a time.
Primary keys seem kind of important?
The API changed recently and some things take time to be implemented efficiently. The issue with primary keys (which are sorted) is that as soon as you push a row, you would need to sort again, so it has to be implemented in a lazy way so that it’s efficient to push many rows. For now, you would have to do it manually. You can always add rows with:
push!(rows(t), @NT(x = 0, y = 0))
But you may end up with a table that thinks some keys are sorted when instead they aren’t. To remedy that, the simple:
table(t, pkey = t.pkey, copy = false)
should sort things in place.