1. A system for data federation query suggestions, the system comprising: a non-transitory memory storing a query constraint database including at least one query constraints; and at least one hardware processor in communication with the non-transitory memory and configured to execute: a query constraint resolver that receives from a user a query to search a federated database comprising a plurality of non-integrated databases using a federated database search engine with a client identity of the user submitting the query and determines if the query satisfies the at least one query constraints for querying the plurality of non-integrated databases without submission of the query to each of the plurality of non-integrated databases, wherein the plurality of non-integrated databases are selected by a data architect for search using the query and stored to disparate memory storages connected over a network, wherein the data architect sets the at least one query constraint on views of result sets from the query of the plurality of non-integrated databases with query suggestions for non-compliant queries based on the client identity, wherein the each of the plurality of non-integrated databases comprise a separate query rule list, and wherein the federated database search engine transforms the query for the each of the plurality of non-integrated databases using the separate query rule list for the each of the plurality of non-integrated databases on receipt of the query; and a query suggestion module that determines a query suggestion if the query does not satisfy at least one query constraints, wherein the query constraint resolver further communicates, to the data architect, search results comprising at least one view for the query from the each of the plurality of non-integrated databases, wherein the at least one view comprises secure data, receives an update for re-optimization of the at least on query constraints from the data architect, wherein the update limits access to the secure data based on the client identity, and updates the at least one query constraints in the query constraint database based on the update for re-optimization received from the data architect.
1. A system for data federation query suggestions, the system comprising: a non-transitory memory storing a query constraint database including at least one query constraints; and at least one hardware processor in communication with the non-transitory memory and configured to execute: a query constraint resolver that receives from a user a query to search a federated database comprising a plurality of non-integrated databases using a federated database search engine with a client identity of the user submitting the query and determines if the query satisfies the at least one query constraints for querying the plurality of non-integrated databases without submission of the query to each of the plurality of non-integrated databases, wherein the plurality of non-integrated databases are selected by a data architect for search using the query and stored to disparate memory storages connected over a network, wherein the data architect sets the at least one query constraint on views of result sets from the query of the plurality of non-integrated databases with query suggestions for non-compliant queries based on the client identity, wherein the each of the plurality of non-integrated databases comprise a separate query rule list, and wherein the federated database search engine transforms the query for the each of the plurality of non-integrated databases using the separate query rule list for the each of the plurality of non-integrated databases on receipt of the query; and a query suggestion module that determines a query suggestion if the query does not satisfy at least one query constraints, wherein the query constraint resolver further communicates, to the data architect, search results comprising at least one view for the query from the each of the plurality of non-integrated databases, wherein the at least one view comprises secure data, receives an update for re-optimization of the at least on query constraints from the data architect, wherein the update limits access to the secure data based on the client identity, and updates the at least one query constraints in the query constraint database based on the update for re-optimization received from the data architect. 2. The system of claim 1 , wherein each of the at least one query constraints include a set of column query patterns having a two component tuple.