I don't think that is in the cards. I don't think agriculture is going to exist with non-fossil fuel technology, because I would certainly include nitrogen fertilizer in that category, due to how it's created through natural gas.
I think the best you could hope for, if your goal was to eventually get to net zero—as the Canadian government has stated—is to get nitrous oxide emissions in line with the rate that's suggested by the social costs of carbon.
Agriculture is not going to get to a place, in the near future, where no fossil fuels are used.