Modifying the question based on Kate Paulk suggestion.
I had a very interesting discussion on Data Validation using Automation
I have summarized Pros and Cons of Reusing Developer Database Queries in Automation
Application Type - OLTP Application with some Reporting Queries
If Application is stable, manually queries are verified. Developer DB queries can be used to verify data rendered is corrrect. Since we reuse developer query there is not exactly any data validation done by automation in this case.
If a query is changed and automation results does not match then it means developer DB Query is changed
If the underlying Developer query is incorrect and we reuse the same in automation. Then we are not catching those defects
If the QA team member rewrites another set of queries for validating the data. There is a possibility this query also can be incorrect
I have done web service automation. I have written custom queries to validate web service results
I support reuse of developer queries if they are validated by manual testing
My Question - I would like to hear from your automation experience. Do you write custom queries / reuse developer queries in your automation framework.
Many thanks in advance for your opinion and sharing your experience