Sorry I know this is a weird (probably dumb) question.
We have a managed package that uses actual salesforce custom object records for its configuration. It is an ecommerce platform where the website content and code is managed as salesforce records. Eg you have a record with a long text field that contains some code (liquid, html, css, and js). There are hundreds of records.
Making edits is a pain, as you can imagine. All the good things about an IDE working with metadata are lost.
I'm wondering if there is a way to overcome this? Basically, is there a way to retrieve salesforce records into a code editor and be able to push them back to the org?
.apexfile in the/scripts/apex/directory of an SFDX project) to query and update records, but that doesn't really sound like what you're after. You wouldn't see the html and such in the editor and get syntax highlighting, etc... Your current solution sounds like shoving everything into the square hole. Are static resources an option (keep your js/html/css as separate files, but inforce-app/main/default/staticresources)?