SQLite PoC: Customer Data Store

I’m putting together a quick proof of concept in SQLite that will let me store and look up basic customer information. The focus is deliberately simple: one clean table that holds a customer’s name, email, and phone number, and a couple of lightweight views that make it easy to retrieve and search that data.

Here’s what I need from you:

• SQLite schema for the customer table, including sensible data types and a primary key
• At least two read-only views that demonstrate typical look-ups—one to return all records, another to search by either name or email
• A few sample INSERT statements and matching SELECT examples so I can see the flow end-to-end

No fancy ORM or external tooling is required; straightforward SQL is perfect. Keep the scripts portable so I can drop them into the SQLite CLI or any GUI tool and run them without tweaks. If you have suggestions on indexing or constraints to keep data clean, include those too.