I have a simple next.js 13 app (typescript) which needs to perform CRUD operations on D1. Currently, I only saw docs for connecting from workers. Is it possible from next.js? also, what about local development?

Yes, you should be able to access your bindings on process.env when deployed to pages or using wrangler. It's not possible to access them with

next dev

, although you can share your thoughts on this issue if that is a problem for you - https://github.com/cloudflare/next-on-pages/issues/271