Originally Posted by Prime Junta
* Irrigation (floodgates, levers, connecting the two, channeling water) =>
needs mason's workshop, mechanic's workshop
* Requirements for farming (muddy floor => getting water at a depth of 1 onto it)

Floodgate farming is mostly obsolete now.
Sand or clay are the way to go, and at least in the current version you dont need to worry about irrigation with them.