是的，AWS OpenSearch支持将普通查询与SQL结合使用。下面是一个使用Java AWS SDK的示例代码：

import software.amazon.awssdk.services.opensearch.OpenSearchClient;
import software.amazon.awssdk.services.opensearch.model.*;

public class OpenSearchExample {

    public static void main(String[] args) {
        String domainName = "your-opensearch-domain-name";
        String query = "SELECT * FROM your-index-name WHERE your-field-name = 'your-field-value'";

        OpenSearchClient openSearchClient = OpenSearchClient.builder().build();

        ExecuteQueryRequest executeQueryRequest = ExecuteQueryRequest.builder()
                .domainName(domainName)
                .queryString(query)
                .build();

        ExecuteQueryResponse executeQueryResponse = openSearchClient.executeQuery(executeQueryRequest);

        // 处理查询结果
        // ...

        openSearchClient.close();
    }
}

请确保将your-opensearch-domain-name替换为您的OpenSearch域的名称，将your-index-name替换为您要查询的索引的名称，将your-field-name和your-field-value替换为您要过滤的字段和值。

此代码示例使用AWS Java SDK的OpenSearchClient来执行查询，并使用ExecuteQueryRequest设置查询字符串。然后，您可以处理返回的ExecuteQueryResponse并提取查询结果。

请注意，您需要在构建OpenSearchClient时提供适当的身份验证和区域信息。